dbt-snowflake v1.4.0rc1

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-rc1 - January 11, 2023

Features

• incremental predicates support (#5680, #310)

Fixes

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

Contributors

• @dave-connors-3 (#310)
• @dbeatty10 (#364, #359, #368)
• @verhey (#271)

dbt-snowflake 1.4.0-b1 - December 15, 2022

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)
• change to anonymous sprocs as the default (#305, #334)

Fixes

• Update the Makefile command for dev (#340, #349)
• change quote policy dataclass field to conform to 3.11 typing (#351, #350)

Under the Hood

• changing python_model test configs to take into account swap for anonymous_sproc as new default (#305, #337)

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)
• @joshuataylor (#294)

Previous Releases

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

• 1.3
• 1.2
• 1.1
• 1.0

dbt-snowflake v1.4.0b1

dbt-snowflake 1.4.0-b1 - December 15, 2022

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)
• change to anonymous sprocs as the default (#305, #334)

Fixes

• Update the Makefile command for dev (#340, #349)
• change quote policy dataclass field to conform to 3.11 typing (#351, #350)

Under the Hood

• changing python_model test configs to take into account swap for anonymous_sproc as new default (#305, #337)

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)
• @joshuataylor (#294)

dbt-snowflake 1.3.0

dbt-snowflake 1.3.0 - October 12, 2022

Features

• Support python model through create stored procedure with python in it, currently supported materializations are table and incremental. (#216, #182)
• retry once by default. exponential backoff for more than one retry. (#205, #207)
• Support query tags in dbt tests using the +query_tag config in dbt_project.yml (#211, #210)
• Array macros (#255, #257)
• Support passing imports to python model(dbt will assume the imports exists in snowflake stage) (#245, #263)
• implement type boolean test for snowflake (#267, #268)

Fixes

• Add pandas as a default package for python models (#228, #229)
• fix incorrect UDF name (#247, #246)
• Skip grants on share objects (#264, #266)

Under the Hood

• Reformat overridden macro location of grants work to a apply_grants.sql file in snowflake (#193, #192)
• Support dbt Core incrmental materialization refactor (#195, #196)
• Add changie to dbt-snowflake (#209, #212)
• Use view instead of temp table for faster 'merge' incremental strategy (#92, #93)
• specify supported_languages for materialization that support python models (#241, #242)
• ignore adapter mypy check (#259, #258)
• Support anonymous sproc as submission method (#256, #260)

Dependency

• Bump mypy from 0.942 to 0.971 (#216, #204)
• Bump black from 22.3.0 to 22.8.0 (#216, #248)
• Update click requirement from ~=8.0.4 to ~=8.1.3 (#216, #151)

Feature

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

Contributors

• @aaron-ortega (#266)
• @colin-rogers-dbt (#258, #273)
• @dbeatty10 (#257)
• @graciegoheen (#257)
• @jnatkins (#93)
• @jpmmcneill (#268)
• @matt-winkler (#210)

dbt-snowflake 1.3.0rc2

dbt-snowflake 1.3.0-rc2 - October 03, 2022

Feature

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

Contributors

• @colin-rogers-dbt (#273)

dbt-snowflake 1.3.0rc1

dbt-snowflake 1.3.0-rc1 - September 28, 2022

Features

• retry once by default. exponential backoff for more than one retry. (#205, #207)
• Array macros (#255, #257)
• Support passing imports to python model(dbt will assume the imports exists in snowflake stage) (#245, #263)
• implement type boolean test for snowflake (#267, #268)

Fixes

• fix incorrect UDF name (#247, #246)
• Skip grants on share objects (#264, #266)

Under the Hood

• Use view instead of temp table for faster 'merge' incremental strategy (#92, #93)
• ignore adapter mypy check (#259, #258)
• Support anonymous sproc as submission method (#256, #260)

Dependency

• Bump mypy from 0.942 to 0.971 (#216, #204)
• Bump black from 22.3.0 to 22.8.0 (#216, #248)
• Update click requirement from ~=8.0.4 to ~=8.1.3 (#216, #151)

Contributors

• @aaron-ortega (#266)
• @colin-rogers-dbt (#258)
• @dbeatty10 (#257)
• @graciegoheen (#257)
• @jnatkins (#93)
• @jpmmcneill (#268)

dbt-snowflake 1.3.0b2

dbt-snowflake 1.3.0-b2 - August 29, 2022

Features

• Support query tags in dbt tests using the +query_tag config in dbt_project.yml (#211, #210)

Fixes

• Add pandas as a default package for python models (#228, #229)

Under the Hood

• Add changie to dbt-snowflake (#209, #212)
• specify supported_languages for materialization that support python models (#241, #242)

Contributors

• @matt-winkler (#210)

dbt-snowflake 1.3.0b1

dbt-snowflake 1.3.0b1 (July 29, 2022)

Features

• support python model through create stored procedure with python in it, currently supported materializations are table and incremental. (#182)

Under the Hood

• Reformat overridden macro location of grants work to a apply_grants.sql file in snowflake (#193, #192)
• Support dbt Core incremental materialization refactor (#195, #196)

dbt-snowflake 1.2.0

dbt-snowflake 1.2.0 (July 26, 2022)

Features

• Add set_query_tag and unset_query_tag to the dbt macro namespace (#133, #132)
• Add grants to materializations (#168, #178)

Fixes

• In multi-query statements, prepend all queries with query comments. Use the last non-COMMIT query to store metadata about the model result. Note: this restores previous (pre-v0.21) behavior for incremental models and snapshots, which will again correctly reflect the number of rows modified in adapter_response.rows_affected (#140, #147, #153)
• Improve column comment handling when persist_docs is enabled (#161)

Under the hood

• Add precommits for this repo (#107)
• Cleanup redundant precommit hook command (#145)
• File rename to match reference to core (#152)
• Bump cryptography restraint upper bound to <37.0.0 (#171)
• Migrate oauth refresh script from core (#175)
• Lift and shift cross-database macros from dbt-utils (#162

Contributors

• @hhobson (#171)
• @robscriva (#132)
• @dbeatty10 (#162
• @LewisDavies (#161)

dbt-snowflake 1.2.0rc1

dbt-snowflake 1.2.0rc1 (July 12, 2022)

Fixes

• In multi-query statements, prepend all queries with query comments. Use the last non-COMMIT query to store metadata about the model result. Note: this restores previous (pre-v0.21) behavior for incremental models and snapshots, which will again correctly reflect the number of rows modified in adapter_response.rows_affected (#140, #147, #153)
• Improve column comment handling when persist_docs is enabled (#161)

Features

• Add grants to materializations (#168, #178)

Contributors

• @LewisDavies (#161)

dbt-snowflake 1.2.0b1

dbt-snowflake 1.2.0b1 (June 24, 2022)

Features

• Add set_query_tag and unset_query_tag to the dbt macro namespace (#133, #132)

Under the hood

• Add precommits for this repo (#107)
• Cleanup redundant precommit hook command (#145)
• File rename to match reference to core (#152)
• Bump cryptography restraint upper bound to <37.0.0 (#171)
• migrate oauth refresh script from core (#175)
• Migrate oauth refresh script from core (#175)
• Lift and shift cross-database macros from dbt-utils (#162

Contributors

• @hhobson (#171)
• @robscriva (#132)
• @dbeatty10 (#162