Release dbt-snowflake v1.9.0 · dbt-labs/dbt-snowflake

dbt-snowflake 1.9.0 - December 09, 2024

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)
Allow configurable pagination on list_relations_without_caching to support users with a large number of objects per schema (#1234)
Support MicrobatchConcurrency (#1260)

Handle non-English Snowflake error message for non-existing schemas (#834)
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)
Dynamic Iceberg table base_location_subpath generation fix. (#1200)
Performance fixes for snowflake microbatch strategy: use temp view instead of table, remove unnecessary 'using' clause (#1228)
Iceberg quoting ignore fix. (#1227)
Use timestamp_tz type in microbatch delete DDL (#1256)
AUTO should no longer lead to rebuilds of dynamic tables. (#1267)

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)
Add telemetry function (#301)
remove SnowflakeAdapterResponse in favor of updated AdapterResponse in base (#1233)
Add iceberg docs url to behavior flag. (#210)
Use new batch context variables over node.config.__dbt_internal ones (#1263)