v1.2.0

v1.2.0

Make sure to read the updated documentation about:

• Profile configuration
• Project configuration

Changelog

Possibly breaking change: connection encryption

For compatibility with MS ODBC Driver 18, the settings Encrypt and TrustServerCertificate are now always added to the connection string.
These are configured with the keys encrypt and trust_cert in your profile.
In previous versions, these settings were only added if they were set to True.

The new version of the MS ODBC Driver sets Encrypt to True by default.
The adapter is following this change and also defaults to True for Encrypt.

The default value for TrustServerConnection remains False as it would be a security risk otherwise.

This means that connections made with this version of the adapter will now have Encrypt=Yes and TrustServerCertificate=No set if you are using the default settings.
You should change the settings encrypt or trust_cert to accommodate for your use case.

Features

• Support for dbt-core 1.2
  • Full support for the new grants config
  • New configuration option: auto_provision_aad_principals - setting this to true will automatically create contained database users linked to Azure AD principals or groups if they don't exist yet when they're being used in grant configs
• Support for MS ODBC Driver 18
• Support automatic retries with new retries setting introduced in core
• The correct owner of a table/view is now visible in generated documentation (and in catalog.json)
• A lot of features of dbt-utils & T-SQL utils are now available out-of-the-box in dbt-core and this adapter. A new release of T-SQL utils will follow.
  • Support for all type_* macros
  • Support for all cross-database macros, except:
  • bool_or
  • listagg will only work in SQL Server 2017 or newer or the cloud versions. The limit_num option is unsupported. DISTINCT cannot be used in the measure.

Fixes

• In some cases the TIMESTAMP would be used as data type instead of DATETIMEOFFSET, fixed that

Chores

• Update adapter testing framework to 1.2.2
• Update pre-commit, tox, pytest and pre-commit hooks
• Type hinting in connection class
• Automated testing with SQL Server 2017, 2019 and 2022
• Automated testing with MS ODBC 17 and MS ODBC 18

Commit changelog: v1.1.0...v1.2.0

v1.2.0rc1

What's Changed

• Automatically provision Azure AD users if enabled by @sdebruyn in #286

Full Changelog: v1.2.0b2...v1.2.0rc1

v1.2.0 (pre-releases)

Possibly breaking change: connection encryption

For compatibility with MS ODBC Driver 18, the settings Encrypt and TrustServerCertificate are now always added to the connection string.
These are configured with the keys encrypt and trust_cert in your profile.
In previous versions, these settings were only added if they were set to True.

The new version of the MS ODBC Driver sets Encrypt to True by default.
The adapter is following this change and also defaults to True for Encrypt.

The default value for TrustServerConnection remains False as it would be a security risk otherwise.

This means that connections made with this version of the adapter will now have Encrypt=Yes and TrustServerCertificate=No set if you are using the default settings.
You should change the settings encrypt or trust_cert to accommodate for your use case.

Features

• Support for dbt-core 1.2
  • Full support for the new grants config
  • New configuration option in the target: auto_provision_aad_principals - setting this to true will automatically create contained database users linked to Azure AD principals or groups if they don't exist yet when they're being used in grant configs
• Support for MS ODBC Driver 18
• Support automatic retries with new retries setting introduced in core
• The correct owner of a table/view is now visible in generated documentation (and in catalog.json)
• A lot of features of dbt-utils & T-SQL utils are now available out-of-the-box in dbt-core and this adapter. A new release of T-SQL utils will follow.
  • Support for all type_* macros
  • Support for all cross-database macros, except:
  • bool_or
  • listagg will only work in SQL Server 2017 or newer or the cloud versions. The limit_num option is unsupported. DISTINCT cannot be used in the measure.

Fixes

• In some cases the TIMESTAMP would be used as data type instead of DATETIMEOFFSET, fixed that

Chores

• Update adapter testing framework to 1.2.1
• Update pre-commit, tox, pytest and pre-commit hooks
• Type hinting in connection class
• Automated testing with SQL Server 2017, 2019 and 2022
• Automated testing with MS ODBC 17 and MS ODBC 18

v1.3.0b1

First beta version with support for dbt 1.3.0
No new features/bugfixes which were not already included in v1.2.0b2

v1.2.0b2

Possibly breaking change: connection encryption

For compatibility with MS ODBC Driver 18, the settings Encrypt and TrustServerCertificate are now always added to the connection string.
These are configured with the keys encrypt and trust_cert in your profile.
In previous versions, these settings were only added if they were set to True.

The new version of the MS ODBC Driver sets Encrypt to True by default.
The adapter is following this change and also defaults to True for Encrypt.

The default value for TrustServerConnection remains False as it would be a security risk otherwise.

This means that connections made with this version of the adapter will now have Encrypt=Yes and TrustServerCertificate=No set if you are using the default settings.
You should change the settings encrypt or trust_cert to accommodate for your use case.

This behaviour might still change in the final release of 1.2.0 based on feedback gathered during the beta phase.

Features

• Support for dbt-core 1.2
• Support for MS ODBC Driver 18
• Support automatic retries with new retries setting introduced in core
• The correct owner of a table/view is now visible in generated documentation (and in catalog.json)
• A lot of features of dbt-utils & T-SQL utils are now available out-of-the-box in dbt-core and this adapter. A new release of T-SQL utils will follow.
  • Support for all type_* macros
  • Support for all cross-database macros, except:
  • bool_or
  • listagg will only work in SQL Server 2017 or newer or the cloud versions. The limit_num option is unsupported. DISTINCT cannot be used in the measure.

Fixes

• In some cases the TIMESTAMP would be used as data type instead of DATETIMEOFFSET, fixed that

Chores

• Update adapter testing framework to 1.2.1
• Update pre-commit, tox, pytest and pre-commit hooks
• Type hinting in connection class
• Automated testing with SQL Server 2017, 2019 and 2022
• Automated testing with MS ODBC 17 and MS ODBC 18

Outstanding work for official release

• Add documentation about new features to official dbt docs pages

v1.2.0b1

Features

• Support for dbt-core 1.2
• Support automatic retries with new retries setting introduced in core
• The correct owner of a table/view is now visible in generated documentation (and in catalog.json)
• A lot of features of dbt-utils & T-SQL utils are now available out-of-the-box in dbt-core and this adapter. A new release of T-SQL utils will follow.
  • Support for all type_* macros
  • Support for all cross-database macros, except:
  • bool_or
  • listagg will only work in SQL Server 2017 or newer or the cloud versions. The limit_num option is unsupported. DISTINCT cannot be used in the measure.

Fixes

• In some cases the TIMESTAMP would be used as data type instead of DATETIMEOFFSET, fixed that

Chores

• Update adapter testing framework to 1.2.1
• Update pre-commit, tox, pytest and pre-commit hooks
• Type hinting in connection class

Outstanding work for next beta release

• Native dbt support for GRANTs as configs
• Add documentation about new features to official dbt docs pages

Full Changelog: v1.1.0...v1.2.0b1

v1.1.0

v1.1.0

See changes included in v1.1.0rc1 below as well

Full changelog can be found here

Fixes

• #251 fix incremental models with arrays for unique keys (@sdebruyn & @johnnytang24)
• #214 fix for sources with spaces in the names (@Freia3)
• #238 fix snapshots breaking when new columns are added (@jakemcaferty)

Chores

• #249 & #250 add Python 3.10 to automated testing (@sdebruyn)
• #248 update all documentation, README and include on dbt docs (@sdebruyn)
• #252 add automated test for #214 (@sdebruyn)

v1.1.0.rc1

Features

• update to dbt 1.1

Fixes

• #194 uppercased information_schema (@TrololoLi)
• #215 Escape schema names so they can contain strange characters (@johnf)

Chores

• Documentation on how to contribute to the adapter
• Automatic release process by adding a new tag
• Consistent code style with pre-commit
• #201 use new dbt 1.0 logger (@semcha)
• #216 use new dbt testing framework (@dataders & @sdebruyn)

List of PRs

• move to 1.0 by @dataders in #181
• set env vars explicitly to fix circle ci check by @sdebruyn in #198
• Pre-commit setup by @sdebruyn in #228
• Fix azsql resume by @sdebruyn in #229
• remove aiohttp dependency by @sdebruyn in #230
• Bump docker/build-push-action from 2.10.0 to 3.0.0 by @dependabot in #222
• Bump docker/login-action from 1.14.1 to 2.0.0 by @dependabot in #221
• Bump docker/metadata-action from 3.7.0 to 4.0.1 by @dependabot in #220
• Escape schema names so they can contain strange characters by @johnf in #215
• uppercased information_schema resolves #193 by @TrololoLi in #194
• New logging by @semcha in #201
• build one docker img per python version by @sdebruyn in #231
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci in #232
• switch to new adapter test framework by @dataders in #216
• Add get_true_sql function for sqlserver adapter to allow snapshots to… by @jakemcaferty in #238
• Bump twine from 4.0.0 to 4.0.1 by @dependabot in #237
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci in #235
• migrate last circleci pipeline to GH actions by @sdebruyn in #240
• run CI tests on trusted PRs and include secrets by @sdebruyn in #239
• remove old integration tests by @sdebruyn in #242
• always run integration tests on Azure on commits to master by @sdebruyn in #243
• do not skip azure tests on master branch by @sdebruyn in #244
• fix version matching by @sdebruyn in #245
• make Docker version available for Python 3.10 by @sdebruyn in #250
• Clean-up and update README by @sdebruyn in #248
• update contribution docs and add Python 3.10 by @sdebruyn in #249
• fix incremental unique array by @sdebruyn in #251
• Fix #213 - dbt test error when source name contains spaces and/or dots by @Freia3 in #214
• add test for sources for PR #214 by @sdebruyn in #252

New Contributors

• @dependabot made their first contribution in #222
• @johnf made their first contribution in #215
• @TrololoLi made their first contribution in #194
• @pre-commit-ci made their first contribution in #232
• @jakemcaferty made their first contribution in #238
• @Freia3 made their first contribution in #214

Full Changelog: v1.0.0...v1.1.0

v1.1.0.rc1

What's Changed

Summary

Full changelog can be found here

Features

• update to dbt 1.1

Fixes

• #194 uppercased information_schema (@TrololoLi)
• #215 Escape schema names so they can contain strange characters (@johnf)

Chores

• Documentation on how to contribute to the adapter
• Automatic release process by adding a new tag
• Consistent code style with pre-commit
• #201 use new dbt 1.0 logger (@semcha)
• #216 use new dbt testing framework (@dataders & @sdebruyn)

Commits & PRs

• move to 1.0 by @dataders in #181
• set env vars explicitly to fix circle ci check by @sdebruyn in #198
• Pre-commit setup by @sdebruyn in #228
• Fix azsql resume by @sdebruyn in #229
• remove aiohttp dependency by @sdebruyn in #230
• Bump docker/build-push-action from 2.10.0 to 3.0.0 by @dependabot in #222
• Bump docker/login-action from 1.14.1 to 2.0.0 by @dependabot in #221
• Bump docker/metadata-action from 3.7.0 to 4.0.1 by @dependabot in #220
• Escape schema names so they can contain strange characters by @johnf in #215
• uppercased information_schema resolves #193 by @TrololoLi in #194
• New logging by @semcha in #201
• build one docker img per python version by @sdebruyn in #231
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci in #232
• switch to new adapter test framework by @dataders in #216

New Contributors

• @dependabot made their first contribution in #222
• @johnf made their first contribution in #215
• @TrololoLi made their first contribution in #194
• @pre-commit-ci made their first contribution in #232

Full Changelog: v1.0.0...v1.1.0.rc1

dbt-sqlserver v1.0.0

Please see dbt-core v1.0.0 release notes for upstream changes

Fixes

• fix index naming when columns contain spaces #175

Under the Hood

• re-organize macros to match new structure #184

dbt-sqlserver v1.0.0rc2

v1.0.0rc2

Fixes

• fix index naming when columns contain spaces #175

Under the Hood

• re-organize macros to match new structure #184

v0.21.1

What's Changed

• Add support for more authentication methods by @sdebruyn in #178
• add column fix for snapshots and incremental mats by @swanderz in #188

New Contributors

• @sdebruyn made their first contribution in #178

Full Changelog: v0.21.0...v0.21.1