search

dbt-msft / dbt-sqlserver

dbt adapter for SQL Server and Azure SQL
MIT License
216 stars 101 forks source link
analytics-engineering azure-sql azure-sql-db data-engineering dbt dbt-sqlserver microsoft microsoft-sql-server mssql sql sql-server t-sql transact-sql tsql

readme

dbt-sqlserver

dbt adapter for Microsoft SQL Server and Azure SQL services.

The adapter supports dbt-core 0.14 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

Debian/Ubuntu

Make sure to install the ODBC headers as well as the driver linked above: ```shell sudo apt-get install -y unixodbc-dev ```

Latest version: PyPI

pip install -U dbt-sqlserver

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

pip install -U --pre dbt-sqlserver

Changelog

See the changelog

Contributing

Unit tests Integration tests on SQL Server 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.

License

PyPI - License

Code of Conduct

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