What's Changed

• Snowflake-Sat_v0: Performance improvement: Move max(ldts) into run_query() (#336) by @tkirschke in #336

Full Changelog: v1.9.7...v1.9.8

What's Changed

• added redshift specific hash_default_values to support SHA2 by @tkirschke in #334

Full Changelog: v1.9.6...v1.9.7

What's Changed

• Adding Upper/Lower case field naming support for Databricks by @diveyseek in #314
• Add databricks column case sensitivity setting via set_casing variable by @tkiehn in #329

New Contributors

• @diveyseek made their first contribution in #314

Full Changelog: v1.9.5...v1.9.6

What's Changed

• fix snowflake md5 binary default values by @tkiehn in #324
• fix yaml_metadata_parser to not treat false values like none values by @tkiehn in #322

Full Changelog: v1.9.4...v1.9.5

What's Changed

• Removed only macro that uses dbt_utils, and packages.yml by @tkirschke in #320

Full Changelog: v1.9.3...v1.9.4

What's Changed

• add optional refer_to_ghost_records parameter to pit macros by @tkiehn in #313
• snapshot control v0 implement end date by @tkiehn in #317
• [Fabric] Move prepend generated by after first with to allow data preview by @tkirschke in #318
• override process_columns_to_select for synapse by @tkiehn in #316

Full Changelog: v1.9.2...v1.9.3

What's Changed

• Eff sat: add rsrc and some improvements by @tkiehn in #304
• add md5-binary support for snowflake by @tkiehn in #310
• fix hashtype and binary ghost records for exasol, synapse, redshift, fabric by @tkiehn in #309
• Fabric specific process_columns_to_select-macro by @tkirschke in #312

Full Changelog: v1.9.1...v1.9.2

What's Changed

• 177 nh link add union strategy parameter by @tkirschke in #303
• add adapter dispatch to process_columns_to_select by @tkiehn in #308

Full Changelog: v1.9.0...v1.9.1

What's Changed

New Features

• Implement new prejoin syntax to allow extraction of multiple columns from the same relation. More info in the docs.
• Implement new method of parameter passing of the macros (you can now directly pass the yaml_metadata-object!) by @tkirschke. More info in the docs.

Bug Fixes

• Redshift: Use QUALIFY statement instead of prep-CTEs to enhance performance by @tkiehn in #302
• fix databricks ghost records for binary datatype by @tkiehn in #301
• Various improvements of ghost records for Bigquery, Oracle, Fabric, Databricks

Full Changelog: v1.8.1...v1.9.0

What's Changed

• Fixed PARTION BY Clause in Sat v0 for Fabric by @tkirschke in #289

Full Changelog: v1.8.0...v1.8.1