Skip to content

Releases: dbt-labs/dbt-redshift

dbt-redshift v1.9.0b2

11 Nov 22:02
Compare
Choose a tag to compare
dbt-redshift v1.9.0b2 Pre-release
Pre-release

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

01 Oct 19:38
Compare
Choose a tag to compare
dbt-redshift v1.9.0b1 Pre-release
Pre-release

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

dbt-redshift v1.8.1

20 Jun 23:03
Compare
Choose a tag to compare

dbt-redshift 1.8.1 - June 20, 2024

Fixes

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

dbt-redshift v1.8.0

09 May 19:48
Compare
Choose a tag to compare

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

dbt-redshift v1.8.0rc1

03 May 23:31
Compare
Choose a tag to compare
Pre-release

dbt-redshift 1.8.0-rc1 - May 03, 2024

Features

  • Support TableLastModifiedMetadataBatch capability (#755)

dbt-redshift v1.8.0b3

19 Apr 00:20
Compare
Choose a tag to compare
dbt-redshift v1.8.0b3 Pre-release
Pre-release

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

Contributors

dbt-redshift v1.7.7

18 Apr 21:17
Compare
Choose a tag to compare

dbt-redshift 1.7.7 - April 18, 2024

Fixes

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

Contributors

dbt-redshift v1.7.6

16 Apr 22:34
Compare
Choose a tag to compare

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 v1.8.0b2

03 Apr 23:46
Compare
Choose a tag to compare
dbt-redshift v1.8.0b2 Pre-release
Pre-release

dbt-redshift 1.8.0-b2 - April 03, 2024

Features

  • Add new workflow for internal patch releases (#38)

Fixes

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

Under the Hood

  • Add unit test for transaction semantics. (#722)

Dependencies

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

dbt-redshift v1.7.5

28 Mar 14:01
Compare
Choose a tag to compare

dbt-redshift 1.7.5 - March 28, 2024

Under the Hood

  • Add unit test for transaction semantics. (#722)