Microsoft Fabric¶
Connects to a Fabric Warehouse or Lakehouse SQL analytics endpoint over the same protocol as SQL Server, on port 1433. Entra ID authentication only — Fabric does not support SQL authentication.
- Host: the SQL connection string host from the Fabric item's Settings →
SQL endpoint page, for example
workspace.datawarehouse.fabric.microsoft.com - Database: the Warehouse or Lakehouse name (its "Initial Catalog")
- Prerequisites: the Fabric tenant setting "Service principals can use Fabric APIs" must be enabled, and the service principal needs Contributor (or an equivalent role) on the workspace or the specific item
Authentication¶
Default port: 1433 - Driver: dbc install mssql
| Auth type | Fields you'll enter |
|---|---|
azure_ad_service_principal |
Username (Entra ID application (client) ID), Password (Client secret) |
azure_ad_managed_identity |
Username (Client ID of a user-assigned identity (optional — omit for system-assigned)) |
azure_ad_default |
Nothing extra |
azure_ad_access_token |
Nothing extra |
Extra parameters:
| Parameter | Applies to | Description |
|---|---|---|
application_client_id |
azure_ad_service_principal |
Entra ID application (client) ID, as an alternative to the Username field. |
client_cert_path |
azure_ad_service_principal |
Path to a client certificate file, as an alternative to a client secret. |
client_id |
azure_ad_managed_identity |
Client ID of a user-assigned managed identity, as an alternative to the Username field. |