BULK INSERT and OPENROWSET added to Fabric Data Warehouse (preview)

🚀

Feb 13 • General

Yesterday, Microsoft introduced two new functions to the Fabric Data Warehouse, you can read more about them in their blog posts here:

OPENROWSET ( Press Release || Documentation )

OPENROWSET allows you to preview the data inside a CSV or Parquet in ADLS GEn2 or Azure Blob. Can also be used with INSERT INTO to pre-filter/ transform data from a CSV/Parquet into a Warehouse table.

BULK INSERT ( Press Release || Documentation )

BULK INSERT is very similar to COPY INTO, but provides a few extra configuration options:

CODEPAGE: This option allows you to load textual files encoded using national encoding.

DATAFILETYPE: This option enables you to read single- or double-byte file formats or native formats produced by SQL Server on-premises.
FORMATFILE: This option allows you to define column and type mappings in a separate textual or XML format file.

How are you going to be using OPENROWSET and BULK INSERT?

6 comments