Skip to content
adapter for dbt sql server
TSQL Python
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
dbt updates for dbt 14.0.1 Sep 5, 2019
.gitignore minor changes to support integration-tests Aug 14, 2019
LICENSE
README.md updated readme Sep 5, 2019
__init__.py Initial commit Jun 27, 2019
setup.py

README.md

dbt-sqlserver

dbt adapter for sql server. Based on pymssql.

Passing all tests in dbt-integration-tests. Only supports dbt 0.14 and newer!

Easiest install is to use pip:

pip install dbt-sqlserver

Since version 0.14.0, pyodbc is used for connecting to SQL Server. It is advised to use the same version of dbt-sqlserver as for dbt.

Configure your profile

Configure your dbt profile for using SQL Server authentication or Integrated Security:

SQL Server authentication
  type: sqlserver
  driver: 'ODBC Driver 17 for SQL Server' (The ODBC Driver installed on your system)
  server: server-host-name or ip
  port: 1433
  user: username
  password: password
  database: databasename
  schema: schemaname
Integrated Security
  type: sqlserver
  driver: 'ODBC Driver 17 for SQL Server'
  server: server-host-name or ip
  port: 1433
  user: username
  schema: schemaname
  windows_login: True

Supported features

Materializations

  • Table:
    • Will be materialized as columns store index by default (requires SQL Server 2017 as least). To override: {{ config( as_columnstore = false, ) }}
  • View
  • Incremental
  • Ephemeral

Seeds

Hooks

Custom schemas

Sources

Testing & documentation

  • Schema test supported
  • Data tests supported from dbt 0.14.1
  • Docs

Snapshots

  • Timestamp
  • Check

But, columns in source table can not have any constraints. If for example any column has a NOT NULL constraint, an error will be thrown.

You can’t perform that action at this time.