# Connect Azure Synapse Analytics

dbt platform

## Supported authentication methods

The supported authentication methods are:

* Microsoft Entra ID service principal
* Active Directory password
* SQL server authentication

### Microsoft Entra ID service principal

The following are the required fields for setting up a connection with Azure Synapse Analytics using Microsoft Entra ID service principal authentication.

| Field              | Description                                                                                                                     |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------- |
| **Server**         | The service principal's **Synapse host name** value (without the trailing string `, 1433`) for the Synapse test endpoint.       |
| **Port**           | The port to connect to Azure Synapse Analytics. You can use `1433` (the default), which is the standard SQL server port number. |
| **Database**       | The service principal's **database** value for the Synapse 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 Azure Synapse Analytics using Active Directory password authentication.

| Field              | Description                                                                                      |
| ------------------ | ------------------------------------------------------------------------------------------------ |
| **Server**         | The server hostname to connect to Azure Synapse Analytics.                                       |
| **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.                                                                      |

### SQL server authentication

The following are the required fields for setting up a connection with Azure Synapse Analytics using SQL server authentication.

| Field              | Description                                                                                      |
| ------------------ | ------------------------------------------------------------------------------------------------ |
| **Server**         | The server hostname or IP to connect to Azure Synapse Analytics.                                 |
| **Port**           | The server port. You can use `1433` (the default), which is the standard SQL server port number. |
| **Database**       | The database name.                                                                               |
| **Authentication** | Choose **SQL** from the dropdown.                                                                |
| **User**           | The username.                                                                                    |
| **Password**       | The username's password.                                                                         |

## Configuration

To learn how to optimize performance with data platform-specific configurations in dbt, refer to [Microsoft Azure Synapse DWH configurations](../../../reference/resource-configs/azuresynapse-configs.md).

## Was this page helpful?

YesNo

[Privacy policy](https://www.getdbt.com/cloud/privacy-policy)[Create a GitHub issue](https://github.com/dbt-labs/docs.getdbt.com/issues)

This site is protected by reCAPTCHA and the Google [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms) apply.