Configuring an ADF Linked Service Connection for Fabric Warehouse
For information on how to enable a connection for use with linked services, see Configuring a Linked Service Connection.
Field labels in this walkthrough follow the underlying Azure Data Factory property names, with the connection column that carries each value named alongside. The exact labels shown in the BimlFlex Connection Editor may differ.
In an Azure Data Factory project, a connection enabled for linked services with the System Type Fabric Warehouse builds an Azure Data Factory Warehouse linked service for the Warehouse, together with its table datasets, copy sources and copy sinks.
The connector uses the same Fabric Warehouse System Type that a Microsoft Fabric project uses.
In a project configured for Microsoft Fabric, a Fabric Warehouse connection follows the Fabric build described in the Microsoft Fabric Configuration Overview. The linked service fields on this page apply to Azure Data Factory projects.
Datasets, Sources and Sinks
The Warehouse table dataset takes the schema and the table from the TargetSchemaName and TargetObjectName parameters, in the same shape as the Azure Synapse Analytics dataset.
The copy source is a Data Warehouse source that reads the Warehouse with a source query.
When the copy lands data in a Fabric Warehouse connection, the copy sink is a Data Warehouse sink that writes to the landing dataset.
Authentication Method
| Method | Credentials | Additional Settings |
|---|---|---|
| Service Principal | Service Principal Id, Service Principal Key and Tenant | None |
Recommendation: Store the Service Principal Key in Azure Key Vault rather than entering it as plaintext.
Complete Example: Service Principal with Azure Key Vault
| Field | Example Value |
|---|---|
| Connect via Integration Runtime | AutoResolveIntegrationRuntime |
| External Reference | {Warehouse Id} |
| Endpoint | {Warehouse SQL Endpoint} |
| Service Principal Id | {Application (Client) Id} |
| Tenant | {Tenant Id} |
| Azure Key Vault Linked Service | bfx-kv |
| Secret Name (for Service Principal Key) | BFX-FabricWarehouse-ServicePrincipalKey |
Required Fields
The required fields for a Fabric Warehouse Linked Service connection are:
- Connect via Integration Runtime
- External Reference
- Endpoint (or the SQL endpoint in the Connection String)
- Service Principal Id
- Service Principal Key (or Azure Key Vault)
- Tenant
The Workspace Id comes from the FabricWorkspaceId setting rather than from a connection field.
Connect via Integration Runtime
Connect via Integration Runtime names the integration runtime for a Fabric Warehouse Linked Service connection.
The default value is AutoResolveIntegrationRuntime.
To use another runtime, select it from the dropdown or choose + New to add one.
When a custom value is saved in the linked service form, it will be added to the custom integration runtimes.
The custom values that appear in this dropdown can be maintained in Settings under Azure - AzureIntegrationRuntime.
Workspace Id
The Workspace Id identifies the Microsoft Fabric workspace that holds the Warehouse.
It comes from the FabricWorkspaceId setting and maps to the ADF workspaceId property.
The connection carries no separate workspace field.
External Reference
The External Reference identifies the Warehouse within the workspace.
It is the connection's External Reference field, entered as described in External Reference, and maps to the ADF artifactId property.
Endpoint
The Endpoint is the SQL endpoint of the Warehouse and maps to the ADF endpoint property.
It is stored in the connection's LS_Endpoint column.
When the Endpoint field is empty, BimlFlex takes the SQL endpoint from the connection's Connection String.
Service Principal
The Fabric Warehouse Linked Service connection authenticates with a service principal.
The generated linked service carries the Authentication Type ServicePrincipal.
The Service Principal Id supplies the client id and is stored in the connection's LS_ServicePrincipalId column.
The Service Principal Key supplies the client secret as plaintext in the LS_ServicePrincipalKey column, or as an Azure Key Vault reference held in the LS_ServicePrincipalKeyKVS_ fields that resolves to the secret at runtime.
The Tenant is stored in the connection's LS_Tenant column and maps to the ADF tenant property.
It is suggested that Azure Key Vault be used in place of manually entering the Service Principal Key.
Azure Data Factory Linked Service Additional Information
For additional information on ADF Microsoft Fabric Warehouse Linked Service and its connection requirements see the Azure Data Factory Microsoft Fabric Warehouse Connector documentation.