dbt-redshift v1.7.0

dbt-redshift 1.7.0 - November 02, 2023

Features

• Support DISTSTYLE for seeds (#255)
• use get_replace_sql in redshift__get_alter_materialized_view_as_sql, avoid renaming materialized views with custom table.sql and view.sql (#606)
• Support storing test failures as views (#6914)

Fixes

• Insert values of merge_exclude_columns when not matched (#563)
• Use the PID to terminate the session (#553)
• allow auto_refresh to take in boolean and str values for materialized views (#560)
• Fix to support removal of hologram, remove unused IAMDuration encoder (#591)
• changes expected value types to AnyInteger to take into account changes in core (#597)
• avoid nested loop in query planner execution of redshift__get_relations (#609)
• Fix parsing of database results for materialized view auto refresh (#643)
• Catalog queries assign the appropriate type for materialized views (#652)

Under the Hood

• Update stale workflow to use the centralized version (#552)
• Update flaky MV tests to use retry logic to avoid "cannot open relation with OID" error (#569)
• Restructure macro files to be more granular; organize macros by relation and type (create, drop, etc.) (#590)
• allow for bool/str input to backup/autorefresh when configuring materialized views (#606)
• Add tests for inlined limit + sql_header in dbt show query (#616)

Dependencies

• Update black requirement from ~=23.3 to ~=23.7 (#529)
• Update pip-tools requirement from ~=6.14 to ~=7.0 (#541)
• Update ddtrace requirement from ~=1.16 to ~=1.17 (#550)
• Update wheel requirement from ~=0.40 to ~=0.41 (#551)
• Update flake8 requirement from ~=6.0 to ~=6.1 (#562)
• Update pip-tools requirement from ~=7.0 to ~=7.2 (#567)
• Update tox requirement from ~=4.6 to ~=4.7 (#570)
• Bump mypy from 1.4.1 to 1.5.0 (#573)
• Update pip-tools requirement from ~=7.2 to ~=7.3 (#572)
• Update ddtrace requirement from ~=1.17 to ~=1.18 (#575)
• Update tox requirement from ~=4.7 to ~=4.8 (#581)
• Bump mypy from 1.5.0 to 1.5.1 (#585)
• Update tox requirement from ~=4.8 to ~=4.9 (#586)
• Update tox requirement from ~=4.9 to ~=4.10 (#588)
• Update tox requirement from ~=4.10 to ~=4.11 (#594)
• Update pre-commit requirement from ~=3.3 to ~=3.4 (#596)
• Update black requirement from ~=23.7 to ~=23.9 (#600)
• Update redshift-connector requirement from ~=2.0.913 to ~=2.0.914 (#601)
• Update ddtrace requirement from ~=1.18 to ~=1.19 (#610)

Contributors

• @WillAyd (#255)
• @slin30 (#609)
• @soksamnanglim (#601)

dbt-redshift v1.6.3

dbt-redshift 1.6.3 - November 01, 2023

Fixes

• Fix parsing of database results for materialized view auto refresh (#643)
• Catalog queries assign the appropriate type for materialized views (#652)

Dependencies

• Update redshift-connector requirement from ~=2.0.913 to ~=2.0.914 (#601)

Contributors

• @soksamnanglim (#601)

dbt-redshift v1.7.0rc1

dbt-redshift 1.7.0-rc1 - October 12, 2023

Features

• Support storing test failures as views (#6914)

Fixes

• Use the PID to terminate the session (#553)
• avoid nested loop in query planner execution of redshift__get_relations (#609)

Under the Hood

• Add tests for inlined limit + sql_header in dbt show query (#616)

Dependencies

• Update ddtrace requirement from ~=1.18 to ~=1.19 (#610)

Contributors

• @slin30 (#609)

dbt-redshift v1.6.2

dbt-redshift 1.6.2 - September 28, 2023

Fixes

• changes expected value types to AnyInteger to take into account changes in core (#597)

Under the Hood

• Add tests for inlined limit + sql_header in dbt show query (#616)

dbt-redshift v1.5.11

dbt-redshift 1.5.11 - September 28, 2023

Under the Hood

• Add tests for inlined limit + sql_header in dbt show query (#616)

dbt-redshift v1.7.0b2

dbt-redshift 1.7.0-b2 - September 15, 2023

Features

• use get_replace_sql in redshift__get_alter_materialized_view_as_sql, avoid renaming materialized views with custom table.sql and view.sql (#606)

Fixes

• allow auto_refresh to take in boolean and str values for materialized views (#560)
• Fix to support removal of hologram, remove unused IAMDuration encoder (#591)
• changes expected value types to AnyInteger to take into account changes in core (#597)

Under the Hood

• Restructure macro files to be more granular; organize macros by relation and type (create, drop, etc.) (#590)
• allow for bool/str input to backup/autorefresh when configuring materialized views (#606)

Dependencies

• Bump mypy from 1.5.0 to 1.5.1 (#585)
• Update tox requirement from ~=4.9 to ~=4.10 (#588)
• Update tox requirement from ~=4.10 to ~=4.11 (#594)
• Update pre-commit requirement from ~=3.3 to ~=3.4 (#596)
• Update black requirement from ~=23.7 to ~=23.9 (#600)

dbt-redshift v1.6.1

dbt-redshift 1.6.1 - August 21, 2023

Under the Hood

• Update flaky MV tests to use retry logic to avoid "cannot open relation with OID" error (#569)

dbt-redshift v1.5.10

dbt-redshift 1.5.10 - August 21, 2023

dbt-redshift v1.7.0b1

dbt-redshift 1.7.0-b1 - August 17, 2023

Features

• Support DISTSTYLE for seeds (#255)

Fixes

• Insert values of merge_exclude_columns when not matched (#563)

Under the Hood

• Update stale workflow to use the centralized version (#552)
• Update flaky MV tests to use retry logic to avoid "cannot open relation with OID" error (#569)

Dependencies

• Update black requirement from ~=23.3 to ~=23.7 (#529)
• Update pip-tools requirement from ~=6.14 to ~=7.0 (#541)
• Update ddtrace requirement from ~=1.16 to ~=1.17 (#550)
• Update wheel requirement from ~=0.40 to ~=0.41 (#551)
• Update flake8 requirement from ~=6.0 to ~=6.1 (#562)
• Update pip-tools requirement from ~=7.0 to ~=7.2 (#567)
• Update tox requirement from ~=4.6 to ~=4.7 (#570)
• Bump mypy from 1.4.1 to 1.5.0 (#573)
• Update pip-tools requirement from ~=7.2 to ~=7.3 (#572)
• Update ddtrace requirement from ~=1.17 to ~=1.18 (#575)
• Update tox requirement from ~=4.7 to ~=4.8 (#581)
• Update tox requirement from ~=4.8 to ~=4.9 (#586)

Contributors

• @WillAyd (#255)

dbt-redshift v1.4.1

dbt-redshift 1.4.1 - August 04, 2023

Breaking Changes

• Drop support for python 3.7 (#dbt-core/7082)

Contributors

• @mikealfare (#dbt-core/7082)