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)

dbt-snowflake v1.5.0b3

dbt-snowflake 1.5.0-b3 - March 16, 2023

Features

• Support Python 3.11 (#331)
• Enforce contracts on models materialized as tables and views (#464, #490)
• take over pr:103 to allow Macro for custom warehouse selection (#438)

Fixes

• Adds query_tag to the tuple returned by SnowflakeCredentials._connection_keys() (#251)
• Raise warning (not error) for custom code with isolated BEGIN; or COMMIT; statements (#388)

Under the Hood

• Replace deprecated set-output command in GitHub workflows (#302)

Dependencies

• Removed explicit dependencies for cryptography and requests (#476)

Security

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

Contributors

• @dataders (#331)
• @javiCalvo (#438)
• @joshuataylor (#331)
• @kevinneville (#302)
• @surbias (#251)

dbt-snowflake v1.4.2

dbt-snowflake 1.4.2 - March 16, 2023

Features

• Support Python 3.11 (#331)

Fixes

• Raise warning (not error) for custom code with isolated BEGIN; or COMMIT; statements (#388)

Dependencies

• Removed explicit dependencies for cryptography and requests (#476)

Security

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

Contributors

• @dataders (#331)
• @dbeatty10 (#476)
• @joshuataylor (#331)
• @mikealfare (#331, #476, #476)

dbt-snowflake v1.3.1

dbt-snowflake 1.3.1 - March 16, 2023

Fixes

• Raise warning (not error) for custom code with isolated BEGIN; or COMMIT; statements (#388)

Dependencies

• Updating the cryptography version upperbound to make sense for current scheme and avoid DDOS vulnerability. (#377)
• Removed explicit dependencies for cryptography and requests (#476)

Security

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

Contributors

• @dbeatty10 (#476)
• @mikealfare (#476, #476)

dbt-snowflake v1.2.1

dbt-snowflake 1.2.1 - March 16, 2023

Features

• Backport changie to dbt-snowflake 1.2 (#216)

Fixes

• Raise warning (not error) for custom code with isolated BEGIN; or COMMIT; statements (#388)

Dependencies

• Raise upperbound on cryptography to avoid vulnerabilities. (#376)
• Removed explicit dependencies for cryptography and requests (#476)

Security

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

Contributors

• @dbeatty10 (#476)
• @mikealfare (#476, #476)

dbt-snowflake v1.1.1

dbt-snowflake 1.1.1 - March 16, 2023

Features

• backport of dbt-changie to 1.1.latest (#216)

Dependencies

• Updating the cryptography version upperbound to make sense for current scheme and avoid DDOS vulnerability.. (#375)
• Removed explicit dependencies for cryptography and requests (#476)

Security

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

Contributors

• @dbeatty10 (#476)
• @mikealfare (#476, #476)

dbt-snowflake v1.5.0b2

dbt-snowflake 1.5.0-b2 - March 02, 2023

Features

• Added ability to configure key-pair authentication with a private key stored in an environment variable (#291)

Fixes

• Fix unset query tag in view materialization (#456)

Under the Hood

• Rename constraints_enabled to contract (#479)

Contributors

• @NiallRees (#456)
• @jayhale (#291)

dbt-snowflake v1.5.0b1

dbt-snowflake 1.5.0-b1 - February 22, 2023

Features

• Support for data types constraints in Snowflake following the dbt Core feature #6271 (#365)
• add back optional old uses of temp tables for incremental models in snowflake for perf increase in some cases (#323)
• Add configurable setting for keeping connections open on Snowflake (#201)

Fixes

• Remove dead code related to dbt.contracts.graph.parsed (#344)
• Respect quoting config in dbt-py models (#330)
• 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)

Under the Hood

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

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)

Contributors

• @b-per (#365)
• @dataders (#374)
• @dave-connors-3 (#410)
• @goFrendiAsgard (#443)
• @joshuataylor (#201)
• @kadekillary (#344)
• @surbias (#466)

dbt-snowflake v1.4.1

dbt-snowflake 1.4.1 - February 08, 2023

Under the Hood

• enable snowpark product team to attribute usage to dbt (#374)

Contributors

• @dataders (#374)

dbt-snowflake v1.4.0

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.4.0 - January 25, 2023

Features

• change when query_tag is set to cut down number of connections needed to increase performance at long distances to conversation with databases (#199, #294)
• incremental predicates support (#5680, #310)
• change to anonymous sprocs as the default (#305, #334)
• add back optional old uses of temp tables for incremental models in snowflake for perf increase in some cases (#323, #389)

Fixes

• Update the Makefile command for dev (#340, #349)
• change quote policy dataclass field to conform to 3.11 typing (#351, #350)
• Comment appropriate lines in test.env.example (#364, #364)
• Incremental models that use temporary tables can no longer collide. (#306, #379)

Under the Hood

• Strip sensitive data from Snowflake merge failure error messages (#123, #271)
• changing python_model test configs to take into account swap for anonymous_sproc as new default (#305, #337)
• Bump upper bound on cryptography to <39.0.0 (#359, #359)
• Consistent capitalization for CONTRIBUTING.md (#368, #368)
• rollback snowflake-connector-python to 2.8.1 to fix testing hangup. (#311, #372)
• Update exceptions to match dbt-core naming. (#366, #384)
• Enable a tmp_relation_type config for applicable incremental models (#402, #403)

Feature

• Migrate dbt-utils current_timestamp macros into core + adapters (#276, #273)

Dependency

• Bump SCP upper bound to <2.9 (#216, #280)

Contributors

• @b-per (#349)
• @dave-connors-3 (#310)
• @dbeatty10 (#389, #364, #359, #368, #403)
• @joshuataylor (#294)
• @verhey (#271)

Previous Releases

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

• 1.3
• 1.2
• 1.1
• 1.0