dbt-labs/dbt-snowflake v1.7.0

dbt-snowflake v1.7.0

on GitHub

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

• @danielefrigo (#656)
• @gabeschenz (#619)
• @jaypeedevlin (#772)
• @jeremyyeo (#776)
• @julio-romero (#711)
• @kaarthik108 (#769, #769)