Fabric Warehouse
After navigating to the add destination page, the following details are required to add Fabric Warehouse as a writeback destination:
SQL connection string
Database name
Schema name
Client ID
Client secret
Table name

Fetching the DB name and connection string

Fetching the Service Principal Client ID and Service Principal Client Secret
Refer to the highlighted fields in the screenshot below to get the Service Principal Client ID. Client Secret is obtained while creating the Service Principal Account.

Additional configuration for optimised insert
To perform bulk insert when there is large data, ensure these items are configured:
1. Create a "Workspace Identity" and then add the "Service Principal" as an "Authorized User".

2. Ensure that the "Workspace Identity" is whitelisted in the "Resource Instance Rules" of the"Storage Account".

Last updated
Was this helpful?