dbt-snowflake Changelog

This file provides a full account of all changes to dbt-snowflake.
Changes are listed under the (pre)release in which they first appear. Subsequent releases include changes from previous releases.
"Breaking changes" listed under a version may require action from end users or external maintainers when upgrading to that version.
Do not edit this file directly. This file is auto-generated using changie. For details on how to document a change, see the contributing guide

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.7.4 - May 15, 2024

Under the Hood

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

dbt-snowflake 1.7.3 - March 28, 2024

Fixes

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)

Under the Hood

Add unit test for transaction semantics. (#912)

Dependencies

bump cryptography to 42.0.4 or higher for security callouts (#940)

dbt-snowflake 1.7.2 - February 16, 2024

Fixes

remove token field from connection keys (#906)

dbt-snowflake 1.7.1 - December 08, 2023

Security

DDOS vulnerability in 41.0.5. Uptick to avoid (#852)

dbt-snowflake 1.7.0 - November 02, 2023

Features

Support replacing tables/views with dynamic tables and vice versa (#753)
Support limiting get_catalog by object name (#758)
Redact cases where raw data can be leaked logs (#772)
Support storing test failures as views (#6914)
Add support for checking table-last-modified by metadata (#785)

Fixes

Incremental materialization with "append" strategy does not wrap dml with explicit transaction (#656)
Fix on_configuration_change setting to properly recognize continue and fail (#708)
Cancel all queries when terminating dbt (#711)
change target_lag type to allow for downstream as a option (#734)
update snowflake_warehouse field for dynamic tables to be more accounted for (#735)
remove senesitive creds from dbt debug stdout (#754)
changes expected value types to AnyInteger to take into account changes in core (#762)
Fixing comment on syntax for dynamic tables (#769)
Make python models use transient config (#776)
Fix the alter syntax on column for dynamic table (#769)
Dynamic tables now show the proper type in catalog queries (#817)

Under the Hood

add pem private key option (#619)
Update stale workflow to use the centralized version (#707)
Restructure macros files - move relation ddl statements into separate files and directories (#750)
Add tests for inlined limit + sql_header in dbt show query (#786)
allow for adding snowflake-python-collector logs to dbt output (#768)
Remove manual refresh of dynamic table when created; Snowflake does this now (#798)

Dependencies

Update black requirement from ~=23.3 to ~=23.7 (#688)
Update pip-tools requirement from ~=6.14 to ~=7.0 (#692)
Update ddtrace requirement from ~=1.16 to ~=1.17 (#704)
Update wheel requirement from ~=0.40 to ~=0.41 (#706)
Update flake8 requirement from ~=6.0 to ~=6.1 (#714)
Update pip-tools requirement from ~=7.0 to ~=7.1 (#722)
Update pip-tools requirement from ~=7.1 to ~=7.2 (#723)
Update tox requirement from ~=4.6 to ~=4.7 (#730)
Update pip-tools requirement from ~=7.2 to ~=7.3 (#731)
Bump mypy from 1.4.1 to 1.5.0 (#733)
Update tox requirement from ~=4.7 to ~=4.8 (#744)
Update ddtrace requirement from ~=1.17 to ~=1.18 (#745)
Update tox requirement from ~=4.8 to ~=4.9 (#748)
Bump mypy from 1.5.0 to 1.5.1 (#749)
Update tox requirement from ~=4.9 to ~=4.10 (#752)
Update tox requirement from ~=4.10 to ~=4.11 (#759)
Update pre-commit requirement from ~=3.3 to ~=3.4 (#760)
Update black requirement from ~=23.7 to ~=23.9 (#765)

Contributors

Previous Releases

For information on prior major and minor releases, see their changelogs: