# dbt-sqlserver
[dbt](https://www.getdbt.com) 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:
* [Profile setup & authentication](https://docs.getdbt.com/reference/warehouse-profiles/mssql-profile)
* [Adapter documentation, usage and important notes](https://docs.getdbt.com/reference/resource-configs/mssql-configs)
Join us on the [dbt Slack](https://getdbt.slack.com/archives/CMRMDDQ9W) to ask questions, get help, or to discuss the project.
## Installation
This adapter requires the Microsoft ODBC driver to be installed:
[Windows](https://docs.microsoft.com/nl-be/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16#download-for-windows) |
[macOS](https://docs.microsoft.com/nl-be/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver16) |
[Linux](https://docs.microsoft.com/nl-be/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16)
<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](https://img.shields.io/pypi/v/dbt-sqlserver?label=latest%20stable&logo=pypi)
```shell
pip install -U dbt-sqlserver
```
Latest pre-release: ![GitHub tag (latest SemVer pre-release)](https://img.shields.io/github/v/tag/dbt-msft/dbt-sqlserver?include_prereleases&label=latest%20pre-release&logo=pypi)
```shell
pip install -U --pre dbt-sqlserver
```
## Changelog
See [the changelog](CHANGELOG.md)
## Contributing
[![Unit tests](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/unit-tests.yml/badge.svg)](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/unit-tests.yml)
[![Integration tests on SQL Server](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-sqlserver.yml/badge.svg)](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-sqlserver.yml)
[![Integration tests on Azure](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-azure.yml/badge.svg)](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-azure.yml)
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](CONTRIBUTING.md).
## License
[![PyPI - License](https://img.shields.io/pypi/l/dbt-sqlserver)](https://github.com/dbt-msft/dbt-sqlserver/blob/master/LICENSE)
## Code of Conduct
This project and everyone involved is expected to follow the [dbt Code of Conduct](https://community.getdbt.com/code-of-conduct).
Raw data
{
"_id": null,
"home_page": "https://github.com/dbt-msft/dbt-sqlserver",
"name": "dbt-sqlserver",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "",
"author": "Mikael Ene, Anders Swanson, Sam Debruyn, Cor Zuurmond",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/09/97/d7244c6ab1ce380ec8ce453ecebe4692325028c7c2fe9863c5fbb163ca04/dbt-sqlserver-1.7.4.tar.gz",
"platform": null,
"description": "# dbt-sqlserver\n\n[dbt](https://www.getdbt.com) adapter for Microsoft SQL Server and Azure SQL services.\n\nThe adapter supports dbt-core 0.14 or newer and follows the same versioning scheme.\nE.g. version 1.1.x of the adapter will be compatible with dbt-core 1.1.x.\n\n## Documentation\n\nWe've bundled all documentation on the dbt docs site:\n\n* [Profile setup & authentication](https://docs.getdbt.com/reference/warehouse-profiles/mssql-profile)\n* [Adapter documentation, usage and important notes](https://docs.getdbt.com/reference/resource-configs/mssql-configs)\n\nJoin us on the [dbt Slack](https://getdbt.slack.com/archives/CMRMDDQ9W) to ask questions, get help, or to discuss the project.\n\n## Installation\n\nThis adapter requires the Microsoft ODBC driver to be installed:\n[Windows](https://docs.microsoft.com/nl-be/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16#download-for-windows) |\n[macOS](https://docs.microsoft.com/nl-be/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver16) |\n[Linux](https://docs.microsoft.com/nl-be/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16)\n\n<details><summary>Debian/Ubuntu</summary>\n<p>\n\nMake sure to install the ODBC headers as well as the driver linked above:\n\n```shell\nsudo apt-get install -y unixodbc-dev\n```\n\n</p>\n</details>\n\nLatest version: ![PyPI](https://img.shields.io/pypi/v/dbt-sqlserver?label=latest%20stable&logo=pypi)\n\n```shell\npip install -U dbt-sqlserver\n```\n\nLatest pre-release: ![GitHub tag (latest SemVer pre-release)](https://img.shields.io/github/v/tag/dbt-msft/dbt-sqlserver?include_prereleases&label=latest%20pre-release&logo=pypi)\n\n```shell\npip install -U --pre dbt-sqlserver\n```\n\n## Changelog\n\nSee [the changelog](CHANGELOG.md)\n\n## Contributing\n\n[![Unit tests](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/unit-tests.yml/badge.svg)](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/unit-tests.yml)\n[![Integration tests on SQL Server](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-sqlserver.yml/badge.svg)](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-sqlserver.yml)\n[![Integration tests on Azure](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-azure.yml/badge.svg)](https://github.com/dbt-msft/dbt-sqlserver/actions/workflows/integration-tests-azure.yml)\n\nThis adapter is community-maintained.\nYou are welcome to contribute by creating issues, opening or reviewing pull requests or helping other users in Slack channel.\nIf you're unsure how to get started, check out our [contributing guide](CONTRIBUTING.md).\n\n## License\n\n[![PyPI - License](https://img.shields.io/pypi/l/dbt-sqlserver)](https://github.com/dbt-msft/dbt-sqlserver/blob/master/LICENSE)\n\n## Code of Conduct\n\nThis project and everyone involved is expected to follow the [dbt Code of Conduct](https://community.getdbt.com/code-of-conduct).\n\n\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "A Microsoft SQL Server adapter plugin for dbt",
"version": "1.7.4",
"project_urls": {
"Changelog": "https://github.com/dbt-msft/dbt-sqlserver/blob/master/CHANGELOG.md",
"Documentation & usage": "https://docs.getdbt.com/reference/resource-configs/mssql-configs",
"Homepage": "https://github.com/dbt-msft/dbt-sqlserver",
"Issue Tracker": "https://github.com/dbt-msft/dbt-sqlserver/issues",
"Setup & configuration": "https://docs.getdbt.com/reference/warehouse-profiles/mssql-profile"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "fb08b19cf69a57b9de1a1f9dd4658fc20b1c28c56ef10753748f323c48a66d8b",
"md5": "bea8079d227bec87dc039d9e37cc39a5",
"sha256": "7b67babca5ad5d7b9be923250e8a32ffe94dfef78ee2d3ce6bd145cc3e157a8d"
},
"downloads": -1,
"filename": "dbt_sqlserver-1.7.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "bea8079d227bec87dc039d9e37cc39a5",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 15484,
"upload_time": "2024-03-04T14:46:39",
"upload_time_iso_8601": "2024-03-04T14:46:39.530485Z",
"url": "https://files.pythonhosted.org/packages/fb/08/b19cf69a57b9de1a1f9dd4658fc20b1c28c56ef10753748f323c48a66d8b/dbt_sqlserver-1.7.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "0997d7244c6ab1ce380ec8ce453ecebe4692325028c7c2fe9863c5fbb163ca04",
"md5": "9973700ab73892028036f75f9281ee12",
"sha256": "b9e85771a1c00e8f4aadefb37b00d02b3d49bc93ad7c52782fd9cae9db31dd98"
},
"downloads": -1,
"filename": "dbt-sqlserver-1.7.4.tar.gz",
"has_sig": false,
"md5_digest": "9973700ab73892028036f75f9281ee12",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 13386,
"upload_time": "2024-03-04T14:46:41",
"upload_time_iso_8601": "2024-03-04T14:46:41.247342Z",
"url": "https://files.pythonhosted.org/packages/09/97/d7244c6ab1ce380ec8ce453ecebe4692325028c7c2fe9863c5fbb163ca04/dbt-sqlserver-1.7.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-03-04 14:46:41",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "dbt-msft",
"github_project": "dbt-sqlserver",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "dbt-sqlserver"
}