Skip to main content

Initial Fabric Data Warehouse Writer setup

This adapter relies on the ADLSGen2 storage area to stage the file and then copies the file content to the Fabric Data Warehouse staging table or target table using the COPY command. Provision an ADLSGen2 storage container before using the adapter (see Learn / Azure / Storage / Blobs / Create a storage account to use with Azure Data Lake Storage). The ADLS network access rule must be Enabled from all networks (see Learn / Azure / Storage / Configure Azure Storage firewalls and virtual networks / Change the default network access rule).

Fabric Data Warehouse Writer requires an Azure Data Lake Storage account, which you must create prior to running this wizard

Driver dependencies

The Fabric Data Warehouse Writer depends on the following drivers which are bundled with Fabric Data Warehouse Writer:

  • The mssql-jdbc driver version 12.8.1 to access tables in Fabric Data Warehouse via SQL endpoint. 

  • The azure-storage-blob driver version 12.18.0 to access the ADLSGen2 storage area to stage the files.