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

Fabric warehouse

Fetching the DB name and connection string

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.

Ensure that this Service principal client ID has Contributor access to the workspace that is added.

Fetching the service principal client ID

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".