Skip to main content

Connect Azure Synapse Analytics

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.

FieldDescription
ServerThe service principal's Synapse host name value (without the trailing string , 1433) for the Synapse test endpoint.
PortThe port to connect to Azure Synapse Analytics. You can use 1433 (the default), which is the standard SQL server port number.
DatabaseThe service principal's database value for the Synapse test endpoint.
AuthenticationChoose Service Principal from the dropdown.
Tenant IDThe service principal's Directory (tenant) ID.
Client IDThe service principal's application (client) ID id.
Client secretThe 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.

FieldDescription
ServerThe server hostname to connect to Azure Synapse Analytics.
PortThe server port. You can use 1433 (the default), which is the standard SQL server port number.
DatabaseThe database name.
AuthenticationChoose Active Directory Password from the dropdown.
UserThe AD username.
PasswordThe 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.

FieldDescription
ServerThe server hostname or IP to connect to Azure Synapse Analytics.
PortThe server port. You can use 1433 (the default), which is the standard SQL server port number.
DatabaseThe database name.
AuthenticationChoose SQL from the dropdown.
UserThe username.
PasswordThe username's password.

Configuration

To learn how to optimize performance with data platform-specific configurations in dbt Cloud, refer to Microsoft Azure Synapse DWH configurations.

0