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)

dbt-snowflake v1.5.0b4

dbt-snowflake 1.5.0-b4 - March 30, 2023

Features

• Modify create_table_as to use column ordering subquery (#498)
• Unified pre-release condition and condition_check properties (#491)

Under the Hood

• Treat contract config as a python object (#479, #539)