Skip to main content

Microsoft Azure Synapse DW Profile

Community plugin

Some core functionality may be limited. If you're interested in contributing, check out the source code for each repository listed below.

Overview of dbt-synapse#

Maintained by: Community
Author: Nandan Hegde and Anders Swanson
Source: Github
Core version: v0.18.0 and newer
dbt Cloud: Not Supported
dbt Slack channel Link to channel

dbt-synapse stars

The package can be installed from PyPI with:

pip install dbt-synapse

For further (and more likely up-to-date) info, see the README

Connecting to Azure Synapse with dbt-synapse#

First download and install the MSFT ODBC Driver 17 for SQL Server

standard SQL Server authentication#

SQL Server credentials are supported for on-prem as well as cloud, and it is the default authentication method for dbt-sqlsever

profiles.yml
type: synapsedriver: 'ODBC Driver 17 for SQL Server' (The ODBC Driver installed on your system)server: server-host-name or ipport: 1433schema: schemanameuser: usernamepassword: password

Active Directory Authentication#

The following pyodbc-supported ActiveDirectory methods are available to authenticate to Azure SQL products:

  • ActiveDirectory Password
  • Azure CLI
  • ActiveDirectory Interactive (Windows only)
  • ActiveDirectory Integrated (Windows only)
  • Service Principal (a.k.a. AAD Application)
  • ActiveDirectory MSI (not implemented)

Windows Only uses your machine's credentials (might be disabled by your AAD admins)

profiles.yml
type: synapsedriver: 'ODBC Driver 17 for SQL Server' (The ODBC Driver installed on your system)server: server-host-name or ipport: 1433schema: schemanameauthentication: ActiveDirectoryIntegrated