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)