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