GitPedia

Dbt synapse

dbt adapter for Azure Synapse Dedicated SQL Pools

From microsoft·Updated June 20, 2026·View on GitHub·

[dbt](https://www.getdbt.com) adapter for Azure Synapse Dedicated SQL Pool (Azure Synapse Data Warehouse). The project is written primarily in Python, distributed under the MIT License license, first published in 2020. Key topics include: azure-sql, azure-sql-database, azure-sql-datawarehouse, synapse-analytics, tsql.

Latest release: v1.8.4
August 19, 2025View Changelog →

dbt-synapse

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.

Documentation

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.

Installation

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

<details><summary>Debian/Ubuntu</summary> <p>

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

shell
sudo apt-get install -y unixodbc-dev
</p> </details>

Latest version: PyPI

shell
pip install -U dbt-synapse

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

shell
pip install -U --pre dbt-synapse

Changelog

See the changelog

Contributing

Integration tests on Azure

This adapter is managed by Microsoft.
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-fabric adapter underneath so make sure to check out that repository as well.

License

PyPI - License

Code of Conduct

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

Contributors

Showing top 12 contributors by commit count.

View all contributors on GitHub →

This article is auto-generated from microsoft/dbt-synapse via the GitHub API.Last fetched: 6/29/2026