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