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: synapse
driver: 'ODBC Driver 17 for SQL Server' (The ODBC Driver installed on your system)
server: server-host-name or ip
port: 1433
schema: schemaname
user: username
password: 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: synapse
driver: 'ODBC Driver 17 for SQL Server' (The ODBC Driver installed on your system)
server: server-host-name or ip
port: 1433
schema: schemaname
authentication: ActiveDirectoryIntegrated