Skip to main content

Microsoft SQL Server 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-sqlserver#

Maintained by: Community
Author: Mikael Ene
Source: Github
Core version: v0.14.0 and newer
dbt Cloud: Not Supported
dbt Slack channel Link to channel

dbt-sqlserver stars

The package can be installed from PyPI with:

pip install dbt-sqlserver

On Ubuntu make sure you have the ODBC header files before installing

sudo apt install unixodbc-dev

Connecting to SQL Server with dbt-sqlserver#

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: sqlserverdriver: '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: sqlserverdriver: 'ODBC Driver 17 for SQL Server' (The ODBC Driver installed on your system)server: server-host-name or ipport: 1433schema: schemanameauthentication: ActiveDirectoryIntegrated