dbt-snowflake v1.6.0rc1

dbt-snowflake 1.6.0-rc1 - July 17, 2023

Features

• Optimize catalog.sql to query only needed tables and columns from information_schema (#216)
• add dbt-snowflake portion of dbt_clone functionality (#7256)
• Enumerate supported features for dynamic tables in 1.6.0rc1 (#dbt-labs/dbt-core#6911)

Fixes

• Remove dependent_projects argument from PartialProject call in unit tests (#7955)
• Implement the new refresh method, remove the flaky workaround (#603)

Under the Hood

• add tests for constraints on model with sql header (#7714)

Dependencies

• Update types-requests requirement from ~=2.28 to ~=2.31 (#622)
• Update tox requirement from ~=4.4 to ~=4.6 (#652)
• Bump mypy from 1.3.0 to 1.4.0 (#670)
• Update pytest requirement from ~=7.3 to ~=7.4 (#674)
• Bump mypy from 1.4.0 to 1.4.1 (#675)
• Update pytest-xdist requirement from ~=3.2 to ~=3.3 (#608)
• Update pre-commit requirement from ~=2.21 to ~=3.3 (#583)
• Update pip-tools requirement from ~=6.13 to ~=6.14 (#683)

Contributors

• @mauricioobgo (#216)

dbt-snowflake v1.5.2

dbt-snowflake 1.5.2 - June 22, 2023

Fixes

• fix redaction of row values in logs and standard out (#589)

Under the Hood

• test foreign key + unique constraint rendering (#7417)
• remove support for python 3.7 (#638)

Contributors

• @schielke (#589)

dbt-snowflake v1.6.0b3

dbt-snowflake 1.6.0-b3 - June 08, 2023

Features

• Add support for dynamic tables (#603)
• Standardize the _connection_keys and debug_query for dbt debug. (#PR754)

Fixes

• fix redaction of row values in logs and standard out (#589)

Under the Hood

• test foreign key + unique constraint rendering (#7417)
• remove support for python 3.7 (#638)

Dependencies

• Bump mypy from 1.2.0 to 1.3.0 (#604)

Contributors

• @schielke (#589)

dbt-snowflake v1.4.3

dbt-snowflake 1.4.3 - May 31, 2023

Fixes

• Address some issues regarding gustom schema overrides. (#393)

dbt-snowflake v1.3.2

dbt-snowflake 1.3.2 - May 31, 2023

Fixes

• Address some issues regarding gustom schema overrides. (#393)

dbt-snowflake v1.5.1

dbt-snowflake 1.5.1 - May 26, 2023

Fixes

• Address some issues regarding gustom schema overrides. (#393)

dbt-snowflake v1.6.0b2

dbt-snowflake 1.6.0-b2 - May 25, 2023

Fixes

• Address some issues regarding gustom schema overrides. (#393)

dbt-snowflake v1.6.0b1

dbt-snowflake 1.6.0-b1 - May 12, 2023

Features

• enable showing more than 10K objects in a schema (#571)

Fixes

• Update signature for execute method (#, #)

Contributors

• @matt-winkler (#571)

dbt-snowflake v1.5.0

dbt-snowflake 1.5.0 - April 27, 2023

Features

• Added ability to configure key-pair authentication with a private key stored in an environment variable (#291)
• Support for data types constraints in Snowflake (#365, #492)
• add back optional old uses of temp tables for incremental models in snowflake for perf increase in some cases (#323)
• Support Python 3.11 (#331)
• Add configurable setting for keeping connections open on Snowflake (#201)
• Enforce contracts on models materialized as tables and views (#464, #490)
• Modify create_table_as to use column ordering subquery (#498)
• Unified pre-release condition and condition_check properties (#491)
• Add model-level constraint support (#493)

Fixes

• Adds query_tag to the tuple returned by SnowflakeCredentials._connection_keys() (#251)
• Remove dead code related to dbt.contracts.graph.parsed (#344)
• Respect quoting config in dbt-py models (#330)
• Raise warning (not error) for custom code with isolated BEGIN; or COMMIT; statements (#388)
• add adapter zone test for merge_exclude_columns (#410)
• Fix a minor typo in the user message for too many objects in a schema (#443)
• Fix unset query tag in view materialization (#456)
• Repair accidental changes to dev-requirements (#558)

Under the Hood

• Replace deprecated set-output command in GitHub workflows (#302)
• Enable a tmp_relation_type config for applicable incremental models (#402)
• enable snowpark product team to attribute usage to dbt (#374)
• remove tox call to integration tests (#382)
• Treat contract config as a python object (#479, #539)

Dependencies

• Updates cryptography dependency to be <40.0.0 (#466)
• Increasing mypy cap to 1.0.0 (#452)
• Bump black to 23.1.0 (#432)
• Removed explicit dependencies for cryptography and requests (#476)

Security

• Update snowflake-connector-python to 3.0 to address CVE-2022-42965 (#476)

Contributors

• @NiallRees (#456)
• @b-per (#365, #492)
• @dataders (#331, #374)
• @dave-connors-3 (#410)
• @goFrendiAsgard (#443)
• @jayhale (#291)
• @joshuataylor (#331, #201)
• @kadekillary (#344)
• @kevinneville (#302)
• @surbias (#251, #466)

dbt-snowflake v1.5.0rc1

dbt-snowflake 1.5.0-rc1 - April 13, 2023

Features

• Added ability to configure key-pair authentication with a private key stored in an environment variable (#291)
• Support for data types constraints in Snowflake (#365, #492)
• add back optional old uses of temp tables for incremental models in snowflake for perf increase in some cases (#323)
• Support Python 3.11 (#331)
• Add configurable setting for keeping connections open on Snowflake (#201)
• Enforce contracts on models materialized as tables and views (#464, #490)
• Modify create_table_as to use column ordering subquery (#498)
• Unified pre-release condition and condition_check properties (#491)
• Add model-level constraint support (#493)

Fixes

• Adds query_tag to the tuple returned by SnowflakeCredentials._connection_keys() (#251)
• Remove dead code related to dbt.contracts.graph.parsed (#344)
• Respect quoting config in dbt-py models (#330)
• Raise warning (not error) for custom code with isolated BEGIN; or COMMIT; statements (#388)
• add adapter zone test for merge_exclude_columns (#410)
• Fix a minor typo in the user message for too many objects in a schema (#443)
• Fix unset query tag in view materialization (#456)
• Repair accidental changes to dev-requirements (#558)

Under the Hood

• Replace deprecated set-output command in GitHub workflows (#302)
• Enable a tmp_relation_type config for applicable incremental models (#402)
• enable snowpark product team to attribute usage to dbt (#374)
• remove tox call to integration tests (#382)
• Treat contract config as a python object (#479, #539)

Dependencies

• Updates cryptography dependency to be <40.0.0 (#466)
• Increasing mypy cap to 1.0.0 (#452)
• Bump black to 23.1.0 (#432)
• Removed explicit dependencies for cryptography and requests (#476)

Security

• Update snowflake-connector-python to 3.0 to address CVE-2022-42965 (#476)

Contributors

• @NiallRees (#456)
• @b-per (#365, #492)
• @dataders (#331, #374)
• @dave-connors-3 (#410)
• @goFrendiAsgard (#443)
• @jayhale (#291)
• @joshuataylor (#331, #201)
• @kadekillary (#344)
• @kevinneville (#302)
• @surbias (#251, #466)