dbt-labs/dbt-snowflake v1.9.0b1

dbt-snowflake v1.9.0b1

on GitHub

dbt-snowflake 1.9.0-b1 - October 01, 2024

Features

• Support refresh_mode and initialize parameters for dynamic tables (#1076)
• Add tests for cross-database cast macro (#1009)
• Cross-database date macro (#1013)
• Replace underscores with hyphens in account IDs to prevent SSL issues (#1068)
• Support JWT Authentication (#1079, #726)
• Improve run times for large projects by reusing connections by default (#1082)
• Improve run times when using key pair auth by caching the private key (#1082)
• Add support for Iceberg table materializations. (#321)
• Microbatch incremental strategy (#1182)
• Add support for Iceberg table format in Dynamic Tables (#1183)
• Add Iceberg format Incremental Models (#321)
• Add support for all on_schema_change incremental model strategies. (#321)

Fixes

• Get catalog metadata for a single relation in the most optimized way using the get_catalog_for_single_relation macro and capability (#1048)
• Update relation caching to correctly identify dynamic tables, accounting for Snowflake's 2024_03 bundle (#1016)
• Rename targets for tables and views use fully qualified names (#1031)
• Surface SSO token expiration in logs (#851)
• return to previous naming convention to return to quoting policy (#1074)
• Fix scenario where using the --empty flag causes metadata queries to contain limit clauses (#1033)
• Use show ... starts with instead of show ... like in _show_object_metadata (#1102)
• Fix issue where dbt-snowflake attempts to drop database roles during grants sync (#1151)

Under the Hood

• Lazy load agate (#953)
• Speedup catalog string comparison by using ilike before equals (#1035)
• Improve memory efficiency of the process_results() override. (#1053)
• Automate all manual integration tests for Dynamic Tables (#1084)
• Add support for experimental record/replay testing. (#1106)
• Remove freezegun as a testing dependency; this package is no longer used (#1136)
• Add support for Python 3.12 (#903)
• Isolating distribution testing (#1130)
• Change behavior flag semantics to log iceberg flag warnings.. (#321)

Dependencies

• Update freezegun requirement from ~=1.3 to ~=1.4 (#869)
• Bump actions/upload-artifact from 3 to 4 (#971)
• Bump dbt-labs/actions from 1.1.0 to 1.1.1 (#1006)
• Bump actions/download-artifact from 3 to 4 (#1007)
• Bump aurelien-baudet/workflow-dispatch from 2 to 4 (#1093)
• Update twine requirement from ~=4.0 to ~=5.1 (#1120)
• Bump pre-commit from 3.7.0 to 3.7.1 (#1119)
• Update wheel requirement from ~=0.42 to ~=0.43 (#1121)
• Update pytest-xdist requirement from ~=3.5 to ~=3.6 (#1122)
• Update tox requirement from ~=4.11 to ~=4.16 (#1135)

Contributors

• @HenkvanDyk,mikealfare (#1076)
• @McKnight-42 (#851, #1074)
• @amardatar (#1082)
• @dwreeves (#953)
• @leahwicz (#1130)
• @llam15 (#1079, #726)
• @mikealfare, (#851)