dbt-sqlserver 0.19.0.1

v0.19.0.1

fixes

• we now use the correct connection string parameter so MSFT can montior dbt adoption in their telemetry. #98

under the hood

• dbt-sqlserver's incremental materialization is now 100% aligneed logically to dbt's global_project behavior! this makes maintaining dbt-sqlserver easier by decreasing code footprint. #102

dbt-sqlserver 0.19.0

v0.19.0

New Features:

• dbt-sqlserver's snapshotting now 100% aligneed logically to dbt's snapshotting behavior! Users can now snapshot 'hard-deleted' record as mentioned in the dbt v0.19.0 release notes. An added benefit is that it makes maintaining dbt-sqlserver by decreasing code footprint. #81 fishtown-analytics/dbt#3003

Fixes:

• small snapshot bug addressed via #81
• support for clustered columnstore index creation pre SQL Server 2016. #88 thanks @alangsbo
• support for scenarios where the target db's collation is different than the server's #87 @alangsbo

Under the hood:

• This adapter has separate CI tests to ensure all the connection methods are working as they should #75

dbt-sqlserver v0.19.0rc2

making this just so we can test dbt-synapse and tsql-utils. not intended for end users

dbt-sqlserver v0.19.0rc1

early release of v0.19.0 for means of testing downstream. in this release, dbt is pinned as a dependency here: dbt-labs/dbt-core@1508564

dbt-sqlserver 0.18.1

New Features:

Adds support for:

• SQL Server down to version 2012
• authentication via:
  • Azure CLI (see #71, thanks @JCZuurmond !), and
  • MSFT ODBC Active Directory options (#53 #55 #58 thanks to @NandanHegde15 and @alieus)
• using a named instance (#51 thanks @alangsbo)
• Adds support down to SQL Server 2012
• The adapter is now automatically tested with Fishtowns official adapter-tests to increase stability when making
  changes and upgrades to the adapter.

Fixes:

• Fix for lack of precision in the snapshot check strategy. Previously when executing two check snapshots the same
  second, there was inconsistent data as a result. This was mostly noted when running the automatic adapter tests.
  NOTE: This fix will create a new snapshot version in the target table
  on first run after upgrade.

dbt-sqlserver 0.18.0

v0.18.0
New Features:
• Adds support for dbt v0.18.0

dbt-sqlserver 0.15.3.1

v0.15.3.1
Fixes:
• Snapshots did not work on dbt v0.15.1 to v0.15.3

dbt-sqlserver 0.15.1

v0.15.1

New Features:

• Ability to define an index in a poosthook

Fixes:

• Previously when a model run was interupted unfinished models prevented the next run and you had to manually delete them. This is now fixed so that unfinished models will be deleted on next run.

dbt-sqlserver 0.15.0

support for dbt v0.15.0

dbt-sqlserver 0.14.1

Overview

This release should be used with corresponding dbt version.