v2-prerelease

What's Changed

• Fix: SHA2 for Multiactive data on databricks by @tkiehn in #350
• fix: snowflake variant ghost records by @tkiehn in #351
• fix: stage macro fails for ms fabric when source table has more than 127 columns by @tkiehn in #354
• feat: add 'join_type' parameter for prejoins in staging by @lorogno in #353
• fix: add namespace to extract_input_columns-macro by @tkiehn in #355
• Metadata Insert macro calls by @tkirschke in #358
• Update README.md by @tkirschke in #361
• Update link to premium package by @tkirschke in #363
• fix: fabric: remove lower in partition by clause of ma_sat_v0 by @tkiehn in #365
• Change default datatype of is_active_column in effectivity satellites to boolean type (where applicable) by @tkiehn in #364
• Fix: Snowflake not recognizing '\v' as vertical tab by @tkiehn in #369
• Add additional_columns Parameter for Hub and Links by @lorogno in #367
• fix: bigquery ghost records for BYTES datatype by @tkiehn in #373
• follow up #354 add [CONCAT_FUNCTION] for fabric__multi_active_concattenated_standardize by @tkiehn in #379
• Update release-v2 with latest changes from main by @tkiehn in #380

New Contributors

• @lorogno made their first contribution in #353

Full Changelog: v1.9.9...v2.1-prerelease

What's Changed

• Deleted quotation marks for syntax by @mszerencse in #450

Full Changelog: v2.2-prerelease...v2.3-prerelease

What's Changed

• Fix/source is single batch required release v2 by @pkumar-data in #449
• Update release-v2-temp from main by @tkiehn in #452

New Contributors

• @pkumar-data made their first contribution in #449

Full Changelog: v2.3-prerelease...v2.4-prerelease

v1.16.1

What's Changed

• feat: snowflake v0_sats optimization of incremental runs by @tkiehn in #420

Full Changelog: v1.16.0...v1.16.1

v1.16.0

What's Changed

• Created Optional Trim Logic for HashDiffs by @Tobias-Pah in #417
• adjust pre code scalefree banner by @jstendel in #416

New Contributors

• @jstendel made their first contribution in #416

Full Changelog: v1.15.1...v1.16.0

v1.15.1

What's Changed

• Fix escaping of ref_keys in ref_sat_v0 by @tkirschke in #414

Full Changelog: v1.15.0...v1.15.1

v1.15.0

Notable changes

New Parameter for PIT-Tables, currently implemented for Snowflake to enhance performance. See #402 and Docs.

Performance Enhancements for rsrc_static-handling on Snowflake. See #403.

Where conditions of ctes for latest entries in Entities is modularized, see #400 and #407.
If you need parameters added to the kwargs, feel free to open a PR!

On Redshift, it was possible for a (nh-)link_hk to be delivered from multiple rsrc_statics and it would not be handled correctly (If already present do not insert). If the source data allows it, this filter can be re-added, see #407.

What's Changed

• PIT Performance Enhancements Snowflake by @umattern in #402
• 196 qol snowflake modularize where in loading statements by @umattern in #400
• rsrc static performance enhancement by @umattern in #403
• 196-fix add snapshot_optimization parameter to fabric by @umattern in #406
• handle case if the same link_hk comes from different rsrc_static on redshift by @tkiehn in #407

New Contributors

• @umattern made their first contribution in #402

Full Changelog: v1.14.0...v1.15.0

v1.14.0

What's Changed

• Full Fusion Compatibility by @tkirschke in #399

Full Changelog: v1.13.0...v1.14.0

v1.13.0

What's Changed

• Multi source selection aware by @mszerencse in #383
• fix databricks sha2 hash standardization for hash_datatype string by @tkiehn in #397

Full Changelog: v1.12.5...v1.13.0

v1.12.5

What's Changed

• Refactor Redshift eff_sat_v0 to use LEFT JOIN instead of WHERE NOT EXISTS for incremental logic by @polat-deniz in #394

Full Changelog: v1.12.4...v1.12.5

v1.12.4

What's Changed

• Feat: add oracle varchar-size variable to multi_active_concattenated_standardise by @tkiehn in #390

Full Changelog: v1.12.3...v1.12.4

v1.12.3

What's Changed

• Redshift performance optimization by @tkiehn in #387

Full Changelog: v1.12.2...v1.12.3