BCP
Data Warehouse · Public preview · Planned
Description
Fabric Data Warehouse will support the bcp utility and the TDS Bulk Load API, enabling high-performance data ingestion from a variety of client tools such as bcp, SSIS, and Azure Data Factory. This integration simplifies bulk data loading into Fabric DW and supports scalable, efficient workflows. Centralized support for these APIs ensures consistency across ingestion pipelines and improves interoperability with existing tools.<br/>An example of a bcp command that loads file content into a DW table:<br/>```bcp dbo.artists in gold_artist.txt -d TextDW -c -S myworkspace.datawarehouse.fabric.microsoft.com -G -U theuser@microsoft.com ```
Change History
-
2026-04-02
Release Date 2026-04-20 -> 2026-09-21 -
2026-03-26
Release Date 2026-03-31 -> 2026-04-20 -
2026-01-13
Release Date 2026-01-27 -> 2026-03-31 -
2025-11-05
Release Date 2025-11-29 -> 2026-01-27 -
2025-10-14
Feature Description Fabric DW will support bcp utility and TDS Bulk Load API. Bulk Load API enables a variety of client tools like bcpSSISADFto load data into Fabric DW. An example of bcp command that is loading a content of a file into the DW table is:```bcp gold.artists in "C:\temp\gold_artist.txt" -d TextDW -c -S "<server name>.datawarehouse.fabric.microsoft.com" -G -U theusert@microsoft.com ``` -> Fabric Data Warehouse will support the bcp utility and the TDS Bulk Load APIenabling high-performance data ingestion from a variety of client tools such as bcpSSISand Azure Data Factory. This integration simplifies bulk data loading into Fabric DW and supports scalableefficient workflows. Centralized support for these APIs ensures consistency across ingestion pipelines and improves interoperability with existing tools.<br/>An example of a bcp command that loads file content into a DW table:<br/>```bcp dbo.artists in gold_artist.txt -d TextDW -c -S myworkspace.datawarehouse.fabric.microsoft.com -G -U theuser@microsoft.com ``` -
2025-09-22
Release Date 2025-09-27 -> 2025-11-29 -
2025-08-28
Roadmap Item Added
Workload: Data Warehouse