Skip to content

CHANGELOG.md

Latest commit

 

History

History
220 lines (142 loc) · 14.1 KB

CHANGELOG.md

File metadata and controls

220 lines (142 loc) · 14.1 KB
Raw

Changelog

  • This file provides a full account of all changes to dbt-redshift
  • The format is based on Keep a Changelog, adheres to Semantic Versioning, and is generated by Changie
  • 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.11.0-rc4 - June 15, 2026

Dependencies

  • Add upper bound <2.0 on dbt-core to prevent pip from resolving to dbt-core 2.0 (Fusion engine), which is incompatible with the python adapter (#2013)

dbt-redshift 1.11.0-rc3 - May 22, 2026

Breaking Changes

  • Remove the redshift_use_show_apis behavior flag. Use the datasharing profile credential instead to enable SHOW/SVV_* APIs for cross-database Datasharing support. (#1621)

Features

  • Add drop_without_cascade profile credential to omit CASCADE from DROP TABLE/VIEW/MATERIALIZED VIEW statements (#1772)

Fixes

  • Enable discovering pre-existing functions by updating list_relations_without_caching to include function relations (#1488)
  • Fix 'Tried to commit transaction but it does not have one open' crash when a transient Redshift error triggers a retry during DROP in fresh_transaction (#1698)
  • Auto-retry 'conflict with concurrent transaction' errors during DROP statements in Redshift (#626)
  • Quote database, schema, and table identifiers in SHOW TABLES/SHOW COLUMNS/SHOW GRANTS/SHOW SCHEMAS so hyphenated names are accepted by Redshift's SHOW APIs (#1884)

Dependencies

  • Bump dbt-adapters floor to 1.24.1 for catalogs v2 and JS UDF support (#1966)

dbt-redshift 1.11.0-rc2 - April 14, 2026

Fixes

  • Gate cross-database USE/RESET USE in pre_model_hook, post_model_hook, create_schema, and drop_schema behind the use_show_apis check to prevent incorrect database switching when datasharing is not enabled (#NA)

dbt-redshift 1.11.0-rc1 - April 06, 2026

Features

  • Add support for granting privileges to Redshift groups and roles via grants config using 'group:' and 'role:' prefixes (#647)
  • Redshift: Use native ALTER COLUMN TYPE for VARCHAR and VARBYTE column size changes; fall back to default for other type changes (#649)
  • Adds support for Redshift session query_group so dbt runs can be tagged for WLM and query logging (#648)
  • Added behavior flag redshift_use_show_apis (default: false) for opting into SVV_*-based metadata queries, required for Datasharing/cross-database. (#1621)
  • Use SVV system views for relation listing when redshift_use_show_apis is enabled (#1622)
  • Migrate list_schemas and check_schema_exists to SVV_ALL_SCHEMAS when redshift_use_show_apis flag is enabled, enabling cross-database schema listing (#1623)
  • Migrate get_columns_in_relation to use svv_all_columns, enabling cross-database column introspection for Datasharing (#1624)
  • list_relations - using SHOW TABLES command to get the relation details instead of using svv_* based tables (#1669)
  • Migrate get_columns_in_relation to use SHOW COLUMNS instead of svv_all_columns (#1672)
  • Migrate list_schemas and check_schema_exists to use SHOW SCHEMAS (#1674)
  • Migrate get_show_grant_sql to use SHOW GRANTS ON TABLE (#1677)
  • Support cross-database create_schema and drop_schema when redshift_use_show_apis is enabled, and deprecate ra3_node as an alias for the behavior flag. (#1693)
  • Migrate catalog macros (get_catalog, get_catalog_relations) to use SHOW TABLES and SVV_REDSHIFT_COLUMNS when redshift_use_show_apis is enabled (#1625)
  • Support metadata-based freshness across databases using SHOW TABLES FROM SCHEMA when redshift_use_show_apis is enabled (#1626)
  • Add support for per-model database switching using USE before model execution and RESET USE after, enabling models targeting a non-default db (#1786)
  • Add allow_concurrent_drops credential option to skip the DROP RLock for projects with no downstream views (#1771)

Fixes

  • Adding friendlier error message when dist is not string for redshift (#651)
  • Fix dbt clone failing when persist_docs adds column comments to late binding views (#622)
  • When persist_docs.columns is enabled, dbt now warns about columns defined in YAML that don't exist in the database and eliminates a duplicate get_columns_in_relation roundtrip via the validate_doc_columns helper. (#1690)
  • Handle missing table_subtype and decouple ra3_node from use_show_apis (#1745)
  • Use the ra3_node config where it was used earlier. (#1750)
  • Remove ra3_node deprecation log until SHOW APIs are GA (#1773)
  • Add datasharing profile credential as an alternative to the redshift_use_show_apis behavior flag for enabling SHOW/SVV_* APIs; either can be used to enable cross-database Datasharing support. (#1621)
  • Add cross-database support for create_schema and drop_schema by issuing USE / RESET USE around schema operations targeting a non-default database (#1786)
  • Fix grant reconciliation failure on clusters with datashares by filtering reserved Redshift roles (ds:, sys:) from standardize_grants_dict (#1808)
  • Filter out internal pg.dropped phantom columns from SHOW COLUMNS results to prevent schema-change errors during cross-database column type alterations (#1816)
  • Revert breaking grants behavior from 1597 behind opt-in flag redshift_grants_extended to prevent unintended revocation of externally-managed role and group grants (#647)

Under the Hood

  • Default redshift_skip_autocommit_transaction_statements to False to preserve legacy transaction behavior. Users can opt-in to skip unnecessary transaction statements by setting the flag to True. (#1538)
  • Fix bug where retryable_exceptions is not iterable with retry_all config param set (#1587)
  • Add datasharing profile variant tests for incremental on_schema_change, incremental unique_key, materialized view basic, and UDFs to catch metadata regressions when SHOW APIs are enabled (#1808)

Contributors

dbt-redshift 1.10.0-rc2 - December 10, 2025

Features

  • Add support for py3.13 (#1475)

Dependencies

  • Update dbt-postgres requirement to allow <2.0 (#1420)

dbt-redshift 1.10.0-rc1 - November 18, 2025

Under the Hood

  • Begin testing that python UDFs aren't supported (#1410)

Dependencies

  • Bump minimum dbt-adapters to 1.19.0█ (#1421)

dbt-redshift 1.10.0-b2 - November 04, 2025

Features

  • Support volatility setting in sql UDFs (#1345)

Under the Hood

  • Test handling of unknown function macro lookup (#1344)

Dependencies

  • Drop support for python 3.9 (#1412)

dbt-redshift 1.10.0-b1 - October 07, 2025

Features

  • Support fine grained controls for tcp keepalive settings (#876)
  • Add support for scalar functions (#1291)

Fixes

  • remove retry_all from add_query and set backoff so it actually backs off (#1095)
  • fix macro naming get_delete_insert_merge_sql (#1032)
  • update alter_relation_add_remove_columns to quote column names (#63)
  • Fix references to function properties in function macros (#1365)

Under the Hood

  • Expand snapshot testing. (#1068)

Contributors

dbt-redshift 1.9.5 - May 13, 2025

Features

  • Add 'serverless_work_group' and 'serverless_acct_id' params to profile and connection calls (#919)

Fixes

  • fix retry_all exception handling (#1069)

Under the Hood

  • allow users to declare redshift_connector debug logging via env var (#1062)

Contributors

dbt-redshift 1.9.4 - April 28, 2025

Features

  • Retry could not open relation with OID query exceptions (#1014)
  • Added retry_all profile config param to retry on all redshift_connector exceptions (#1014)

Fixes

  • datetime.datetime.utcnow() is deprecated as of Python 3.12 (#980)

dbt-redshift 1.9.3 - April 01, 2025

Features

  • Add IdpTokenAuthPlugin authentication method. (#898)
  • Make source and target tables able to be referenced via DBT_INTERNAL_DEST and DBT_INTERNAL_SOURCE for the delete/insert incremental strategy (#910)

Under the Hood

  • Add retry logic for retryable exceptions (#960)
  • Move from setup.py to pyproject.toml and to hatch as a dev tool (#951)
  • Refactor to use new batch context varaibles (#966)

dbt-redshift 1.9.2 - March 12, 2025

Fixes

  • Fix regression to re-enable browser-based IDC authentication (#904)

dbt-redshift 1.9.1 - March 07, 2025

Features

  • Add 'is_serverless' param to profile and connection calls (#819)

Under the Hood

  • Handle Gracefully handle null result from backend_pid check (#821)

Previous Releases

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