Initial Fabric Data Warehouse Writer setup

Fabric Data Warehouse Writer uses ADLSGen2 storage to stage files before copying the file content to the Fabric Data Warehouse staging table or target table using the COPY command. Before using the adapter, you must provision an ADLSGen2 storage container (see Learn / Azure / Storage / Blobs / Create a storage account to use with Azure Data Lake Storage).

You can configure storage access using one of the following approaches:

Public network access: Enable public access from all networks on the ADLS storage account. This is suitable for non-production environments or when private connectivity is not required. Set the ADLS network access rule to Enabled from all networks (see Learn / Azure / Storage / Configure Azure Storage firewalls and virtual networks / Change the default network access rule).
Trusted workspace access: Use Fabric workspace identity with private endpoints to securely access a private Azure Storage account without exposing it to the public internet. This approach is recommended for production environments requiring enhanced security and compliance. See Using trusted workspace access with Fabric Data Warehouse Writer for configuration details.

Driver dependencies

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

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.