1.2.0

Support everything (AFAIK) of what is in dbt_date and what is covered with the integration tests provided by dbt_date

1.1.0

Add shim for dbt_utils.test_expression_is_true

1.0.0

Update the package to support all the new adapter versions based on Fabric. Remove documentation which was not maintained.

0.10.0

What's Changed

• Update references of cross-database macros by @BastiaanRudolf in #90

New Contributors

• @BastiaanRudolf made their first contribution in #90

Full Changelog: 0.9.0...0.10.0

0.9.0

v0.9.0

• Move cross-db macros to dbt-sqlserver / dbt-synapse
• Update to match latest source packages
• Correct some small errors
• Update existing overriden macros to match the arguments in the updated source versions
• Support [deduplicate] from dbt_utils by @judahrand (#78)

New Contributors

• @needbrew made their first contribution in #86
• @ataft made their first contribution in #83
• @judahrand made their first contribution in #78

Full Changelog: 0.8.1...0.9.0

tsql-utils 0.8.1

We're back!!! dbt test definitions have been broken for a very long time in TSQL, this is now resolved. As such this package was finally able to be brought back under control again and up-to-date

dependent pacakge versions

This pacakge will work best with dbt-sqlserver and dbtsynapse versions 0.21.0 and greater. Below are the package versions with which this package was built/tested.

• dbt-utils 0.7.4
• dbt-date 0.4.1
• dbt-audit-helper 0.4.0
• dbt-expectations ???

What's Changed

• tsql-utils v0.8.1 by @swanderz in #59
• add docs by @swanderz in #72
• deprecate manual synapse dispatches by @swanderz in #64
• update docs by @swanderz in #73
• Updated docs to show current support model
• Fishtown -> dbt-labs by @visch in #55

New Contributors

• @visch made their first contribution in #55
• @davidclarance made their first contribution in #56
• @timdenouden made their first contribution in #58

Full Changelog: 0.8.0...0.8.1

tsql-utils 0.8.0

What's Changed

• Fishtown -> dbt-labs by @visch in #55
• The insert by period materialization for TSQL by @davidclarance in #56
• Add schema cleanup macros by @timdenouden in #58
• update docs to show new disptach config instead of the extra var you had to add

New Contributors

• @visch made their first contribution in #55
• @davidclarance made their first contribution in #56
• @timdenouden made their first contribution in #58

Full Changelog: 0.7.1...0.8.0

tql-utils `v0.7.1`

tsql-utils v0.7.1

fixes

fix to make the commented out SQL in audit_helper.compare_queries() TSQL compatible #54

tsql-utils v0.7.0

tsql-utils v0.7.0

New features

• shim dbt-audit-helper, currently supports v0.3.0 : compare_relations, compare_queries and compare_column_values. Target to support compare_relation_columns in the next release. Thanks @clrcrl for the support!
• shim dbt-expectations, currently supports v0.3.3 with most functionalities implemented. Limitations with regex and timeseries functionalities mostly for Synapse (Target next release to implement these). Thanks @b-per and @clausherther for the support!

Also supports

• dbt-utils - v0.6.6 (partial)
• dbt-date - v0.2.6 (partial)

tsql-utils v0.6.7

tsql-utils v0.6.7

New features

• add support for dbt_utils.surrogate_key() #32 thanks @infused-kim
• shim dbt-date, currently passing all tests! #36 thanks @b-per
• support for dbt_utils.generate_series() #36
• support on synapse for dbt_utils.dateadd() and dbt_utils.datediff() #36

Under the hood

• add CI infrastucture for dbt-date and dbt-expectations #35 thanks to @b-per for all the heaving lifting with calogica/dbt-expectations #29, calogica/dbt-date #14, and calogica/dbt-date #15
• docs refresh