Connect Microsoft Fabric
Supported authentication methods
The supported authentication methods are:
- Azure Active Directory (Azure AD) service principal
- Azure AD password
SQL password (LDAP) is not supported in Microsoft Fabric Synapse Data Warehouse so you must use Azure AD. This means that to use Microsoft Fabric in dbt Cloud, you will need at least one Azure AD service principal to connect dbt Cloud to Fabric, ideally one service principal for each user.
Active Directory service principal
The following are the required fields for setting up a connection with a Microsoft Fabric using Azure AD service principal authentication.
| Field | Description |
|---|---|
| Server | The service principal's host value for the Fabric test endpoint. |
| Port | The port to connect to Microsoft Fabric. You can use 1433 (the default), which is the standard SQL server port number. |
| Database | The service principal's database value for the Fabric test endpoint. |
| Authentication | Choose Service Principal from the dropdown. |
| Tenant ID | The service principal's Directory (tenant) ID. |
| Client ID | The service principal's application (client) ID id. |
| Client secret | The service principal's client secret (not the client secret id). |
Active Directory password
The following are the required fields for setting up a connection with a Microsoft Fabric using Azure AD password authentication.
| Field | Description |
|---|---|
| Server | The server hostname to connect to Microsoft Fabric. |
| Port | The server port. You can use 1433 (the default), which is the standard SQL server port number. |
| Database | The database name. |
| Authentication | Choose Active Directory Password from the dropdown. |
| User | The AD username. |
| Password | The AD username's password. |
Configuration
To learn how to optimize performance with data platform-specific configurations in dbt Cloud, refer to Microsoft Fabric DWH configurations.
0