dbt-snowflake 1.9.0 - December 09, 2024

Breaking Changes

• Drop support for Python 3.8 (#1211)

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

Fixes

• 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)

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)
• 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)

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)
• @pei0804 (#834)

dbt-snowflake 1.9.0-rc1 - December 02, 2024

Breaking Changes

• Drop support for Python 3.8 (#1211)

Features

• Allow configurable pagination on list_relations_without_caching to support users with a large number of objects per schema (#1234)

Fixes

• Handle non-English Snowflake error message for non-existing schemas (#834)
• 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)

Under the Hood

• Add telemetry function (#301)
• remove SnowflakeAdapterResponse in favor of updated AdapterResponse in base (#1233)
• Add iceberg docs url to behavior flag. (#210)

Contributors

• @pei0804 (#834)

dbt-snowflake 1.8.4 - October 17, 2024

Fixes

• Fix scenario where using the --empty flag causes metadata queries to contain limit clauses (#1033)

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)

dbt-snowflake 1.8.3 - June 12, 2024

Fixes

• return to previous naming convention to return to quoting policy (#1074)

dbt-snowflake 1.8.2 - May 23, 2024

Fixes

• Update relation caching to correctly identify dynamic tables, accounting for Snowflake's 2024_03 bundle (#1016)

dbt-snowflake 1.7.5 - May 22, 2024

Fixes

• Update relation caching to correctly identify dynamic tables, accounting for Snowflake's 2024_03 bundle (#1016)

dbt-snowflake 1.8.1 - May 15, 2024

Under the Hood

• Speedup catalog string comparison by using ilike before equals (#1035)

dbt-snowflake 1.7.4 - May 15, 2024

Under the Hood

• Speedup catalog string comparison by using ilike before equals (#1035)

dbt-snowflake 1.8.0 - May 09, 2024

Features

• Update base adapter references as part of decoupling migration (#882)
• Support primative types + object, variant, array in snowflake for unit testing" (#898)
• Add new workflow for internal patch releases (#38)
• Add external_access_integration and secret to python models (#955)
• Support TableLastModifiedMetadataBatch capability (#965)

Fixes

• Dynamic tables now show the proper type in catalog queries (#817)
• remove token field from connection keys (#906)
• Acknowledge send_anonymous_usage_stats setting for python models (#830)
• modify metadata queries to take into account object type of BASE TABLE being assigned to dynamic tables when was null previously (#934)
• remove private_key_path from connection keys (#949)
• test contract enforcement for GEOGRAPHY and GEOMETRY types (#894)
• skipping a test that provides a false condition (#976)
• Fix duplicate alias being added when running a model with inline refs and --empty (#980)

Under the Hood

• Add tests for --empty flag (#837)
• Migrate to dbt-common and dbt-adapters package (#890)
• Add unit test for transaction semantics. (#912)
• Update dependabot to cover GHA (#967)

Dependencies

• Update ddtrace requirement from ~=1.18 to ~=1.19 (#780)
• Update pre-commit-hooks requirement from ~=4.4 to ~=4.5 (#795)
• Bump mypy from 1.5.1 to 1.6.0 (#799)
• Update pre-commit requirement from ~=3.4 to ~=3.5 (#807)
• Update black requirement from ~=23.9 to ~=23.10 (#809)
• Bump mypy from 1.6.0 to 1.6.1 (#821)
• Update ddtrace requirement from ~=1.19 to ~=2.1 (#822)
• Update black requirement from ~=23.10 to ~=23.11 (#826)
• Bump mypy from 1.6.1 to 1.7.0 (#828)
• Update pytest-xdist requirement from ~=3.3 to ~=3.4 (#829)
• Update ddtrace requirement from ~=2.1 to ~=2.2 (#832)
• Update wheel requirement from ~=0.41 to ~=0.42 (#844)
• Update ddtrace requirement from ~=2.2 to ~=2.3 (#848)
• Update pytest-xdist requirement from ~=3.4 to ~=3.5 (#849)
• Bump mypy from 1.7.0 to 1.7.1 (#850)
• Update freezegun requirement from ~=1.2 to ~=1.3 (#860)
• Update black requirement from ~=23.11 to ~=23.12 (#864)
• hard pin ddtrace to 2.3.0 (#932)
• bump cryptography to 42.0.4 or higher for security callouts (#938)
• Add dbt-core as a dependency to preserve backwards compatibility for installation (#964)
• Bump actions/github-script from 6 to 7 (#970)
• Bump dorny/paths-filter from 2 to 3 (#972)
• Bump actions/setup-python from 4 to 5 (#973)
• Bump actions/checkout from 3 to 4 (#974)

Security

• DDOS vulnerability in 41.0.5. Uptick to avoid (#852)
• Pin black>=24.3 in dev-requirements.txt (#959)

Contributors

• @Lindblomsebastian (#955)