Skip to main content

An Azure Synapse adapter plugin for dbt

Project description


dbt adapter for Azure Synapse Dedicated SQL Pool (Azure Synapse Data Warehouse).

The adapter supports dbt-core 0.18 or newer and follows the same versioning scheme. E.g. version 1.1.x of the adapter will be compatible with dbt-core 1.1.x.


We've bundled all documentation on the dbt docs site:

Join us on the dbt Slack to ask questions, get help, or to discuss the project.


This adapter requires the Microsoft ODBC driver to be installed: Windows | macOS | Linux


Make sure to install the ODBC headers as well as the driver linked above:

sudo apt-get install -y unixodbc-dev

Latest version: PyPI

pip install -U dbt-synapse

Latest pre-release: GitHub tag (latest SemVer pre-release)

pip install -U --pre dbt-synapse


See the changelog


Integration tests on Azure

This adapter is community-maintained. You are welcome to contribute by creating issues, opening or reviewing pull requests or helping other users in Slack channel. If you're unsure how to get started, check out our contributing guide.

This adapter uses the dbt-sqlserver adapter underneath so make sure to check out that repository as well.


PyPI - License

Code of Conduct

This project and everyone involved is expected to follow the dbt Code of Conduct.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt-synapse-1.3.2.tar.gz (10.9 kB view hashes)

Uploaded source

Built Distribution

dbt_synapse-1.3.2-py3-none-any.whl (13.3 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page