dbt-redshift v1.9.0

dbt-redshift 1.9.0 - December 09, 2024

Breaking Changes

• Drop support for Python 3.8 (#931)

Features

• Support IAM user auth via direct parameters, in addition to the existing profile method (#760)
• Add support for IAM Role auth (#623)
• Add tests for cross-database cast macro (#804)
• Cross-database date macro (#808)
• Remove pg_catalog from metadata queries (#555)
• Add microbatch strategy (#923)
• Add browser identity center authentication method. (#898)

Fixes

• Stop adding aliases to subqueries when calling with --empty (#782)
• Support IAM Role authentication for Redshift Serverless (#835)
• Fix config change detection not working for multiple sortkey in materialized views (#838)
• update pin range for redshift-connector to allow 2.1.0 (#844)
• Handle unit test fixtures where typing goes wrong from first value in column being Null. (#821)
• Fix materialized views comment syntax (#837)
• add InterfaceError to retryable_exceptions (#661)
• Support DROP CASCADE for materialized views; fixes bug that occurs when running dbt on materialized views that reference other materialized views (#642)
• Restrict behavior change warnings to firing once per run to avoid noisy logs (#915)
• Remove redshift_connector's get_columns method for column metadata generation, avoiding a warning on every run (#914)

Under the Hood

• Lazy load agate (#745)
• Remove freezegun as a testing dependency; this package is no longer used (#1136)

Dependencies

• Update freezegun requirement from ~=1.3 to ~=1.4 (#695)
• Bump dbt-labs/actions from 1.1.0 to 1.1.1 (#762)
• Bump actions/checkout from 3 to 4 (#802)
• Bump pre-commit from 3.7.0 to 3.7.1 (#867)
• Update tox requirement from ~=4.11 to ~=4.16 (#870)
• Update twine requirement from ~=4.0 to ~=5.1 (#876)

Contributors

• @dwreeves (#745)
• @fleid (#835)
• @jeremyyeo (#837)
• @jiezhen-chen (#555)
• @lvitti (#838)
• @mikealfare, (#555)
• @mikealfare,abbywh (#623)

dbt-redshift v1.9.0rc1

dbt-redshift 1.9.0-rc1 - December 02, 2024

Features

• Add browser identity center authentication method. (#898)

dbt-redshift v1.9.0b2

dbt-redshift 1.9.0-b2 - November 11, 2024

Breaking Changes

• Drop support for Python 3.8 (#931)

Features

• Add microbatch strategy (#923)

Fixes

• add InterfaceError to retryable_exceptions (#661)
• Restrict behavior change warnings to firing once per run to avoid noisy logs (#915)
• Remove redshift_connector's get_columns method for column metadata generation, avoiding a warning on every run (#914)

dbt-redshift v1.9.0b1

dbt-redshift 1.9.0-b1 - October 01, 2024

Features

• Support IAM user auth via direct parameters, in addition to the existing profile method (#760)
• Add support for IAM Role auth (#623)
• Add tests for cross-database cast macro (#804)
• Cross-database date macro (#808)
• Remove pg_catalog from metadata queries (#555)

Fixes

• Stop adding aliases to subqueries when calling with --empty (#782)
• Support IAM Role authentication for Redshift Serverless (#835)
• Fix config change detection not working for multiple sortkey in materialized views (#838)
• update pin range for redshift-connector to allow 2.1.0 (#844)
• Handle unit test fixtures where typing goes wrong from first value in column being Null. (#821)
• Fix materialized views comment syntax (#837)
• Support DROP CASCADE for materialized views; fixes bug that occurs when running dbt on materialized views that reference other materialized views (#642)

Under the Hood

• Lazy load agate (#745)
• Remove freezegun as a testing dependency; this package is no longer used (#1136)

Dependencies

• Update freezegun requirement from ~=1.3 to ~=1.4 (#695)
• Bump dbt-labs/actions from 1.1.0 to 1.1.1 (#762)
• Bump actions/checkout from 3 to 4 (#802)
• Bump pre-commit from 3.7.0 to 3.7.1 (#867)
• Update tox requirement from ~=4.11 to ~=4.16 (#870)
• Update twine requirement from ~=4.0 to ~=5.1 (#876)

Contributors

• @dwreeves (#745)
• @fleid (#835)
• @jeremyyeo (#837)
• @jiezhen-chen (#555)
• @lvitti (#838)
• @mikealfare, (#555)
• @mikealfare,abbywh (#623)

dbt-redshift v1.8.1

dbt-redshift 1.8.1 - June 20, 2024

Fixes

• Stop adding aliases to subqueries when calling with --empty (#782)

dbt-redshift v1.8.0

dbt-redshift 1.8.0 - May 09, 2024

Features

• allow user to set debug level for redshift-connector via env var (#650)
• Support limiting get_catalog by object name (#625)
• Add support for checking table-last-modified by metadata (#615)
• Add new workflow for internal patch releases (#38)
• Support TableLastModifiedMetadataBatch capability (#755)

Fixes

• Fix parsing of database results for materialized view auto refresh (#643)
• Fix describe_materialized_view for Redshift Serverless (#641)
• Catalog queries assign the appropriate type for materialized views (#652)
• Fix handling of backup parameter during config change monitoring (#621)
• Initialize sqlparse.Lexer to resolve issue with dbt docs generate that includes external tables (#710)
• Pin redshift-connector to <2.0.918 to avoid SSL error introduced in 2.0.918 (#730)
• dbt can cancel open queries upon interrupt (#705)

Under the Hood

• Add tests for --empty flag (#667)
• Update base adapter references as part of decoupling migration (#698)
• Add unit test for transaction semantics. (#722)
• Update dependabot config to cover GHA (#759)

Dependencies

• Update redshift-connector requirement from ~=2.0.913 to ~=2.0.914 (#601)
• Update ddtrace requirement from ~=1.19 to ~=1.20 (#622)
• Update pre-commit-hooks requirement from ~=4.4 to ~=4.5 (#627)
• Bump mypy from 1.5.1 to 1.6.0 (#629)
• Update pre-commit requirement from ~=3.4 to ~=3.5 (#634)
• Update black requirement from ~=23.9 to ~=23.10 (#636)
• Bump mypy from 1.6.0 to 1.6.1 (#648)
• Update ddtrace requirement from ~=1.20 to ~=2.1 (#651)
• Update black requirement from ~=23.10 to ~=23.11 (#660)
• Bump mypy from 1.6.1 to 1.7.0 (#662)
• Update pytest-xdist requirement from ~=3.3 to ~=3.4 (#664)
• Update ddtrace requirement from ~=2.1 to ~=2.2 (#665)
• Update ddtrace requirement from ~=2.2 to ~=2.3 (#669)
• Update wheel requirement from ~=0.41 to ~=0.42 (#670)
• Update pytest-xdist requirement from ~=3.4 to ~=3.5 (#672)
• Remove direct boto3 dependency (#674)
• Bump mypy from 1.7.0 to 1.7.1 (#676)
• Update freezegun requirement from ~=1.2 to ~=1.3 (#681)
• Update black requirement from ~=23.11 to ~=23.12 (#688)
• upgrade redshift driver to 2.0.918 (#700)
• Migrate to dbt-common and dbt-adapters (#706)
• hard pin ddtrace (#733)
• Add dbt-core as a dependency to preserve backwards compatibility for installation (#756)

Security

• Pin black>=24.3 in dev-requirements.txt (#743)
• Bump sqlparse to >=0.5.0, <0.6.0 to address GHSA-2m57-hf25-phgg along with dbt-core (#768)

Contributors

• @hexDoor (#674)
• @holly-evans (#705)
• @reptillicus (#641)
• @soksamnanglim (#601)

dbt-redshift v1.8.0rc1

dbt-redshift 1.8.0-rc1 - May 03, 2024

Features

• Support TableLastModifiedMetadataBatch capability (#755)

dbt-redshift v1.8.0b3

dbt-redshift 1.8.0-b3 - April 18, 2024

Fixes

• dbt can cancel open queries upon interrupt (#705)

Under the Hood

• Update dependabot config to cover GHA (#759)

Security

• Bump sqlparse to >=0.5.0, <0.6.0 to address GHSA-2m57-hf25-phgg along with dbt-core (#768)

Contributors

• @holly-evans (#705)

dbt-redshift v1.7.7

dbt-redshift 1.7.7 - April 18, 2024

Fixes

• dbt can cancel open queries upon interrupt (#705)

Contributors

• @holly-evans (#705)

dbt-redshift v1.7.6

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)