dbt-redshift Changelog

This file provides a full account of all changes to dbt-redshift.
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-redshift 1.7.7 - April 18, 2024

Fixes

dbt can cancel open queries upon interrupt (#705)

Contributors

@holly-evans (#705)

dbt-redshift 1.7.6 - April 16, 2024

Fixes

Pin redshift-connector to <2.0.918 to avoid SSL error introduced in 2.0.918 (#730)

dbt-redshift 1.7.5 - March 28, 2024

Under the Hood

Add unit test for transaction semantics. (#722)

dbt-redshift 1.7.4 - February 29, 2024

Features

Support limiting get_catalog by object name (#625)
Add support for checking table-last-modified by metadata (#615)

dbt-redshift 1.7.3 - February 09, 2024

Fixes

Initialize sqlparse.Lexer to resolve issue with dbt docs generate that includes external tables (#710)

dbt-redshift 1.7.2 - January 18, 2024

Dependencies

upgrade redshift driver constraint to allow for <=2.0.918, >=2.0.913 (#703)

dbt-redshift 1.7.1 - December 07, 2023

Fixes

Fix describe_materialized_view for Redshift Serverless (#641)

Dependencies

Remove direct boto3 dependency (#674)

Contributors

@hexDoor (#674)
@reptillicus (#641)

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

Previous Releases

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