dbt-redshift 1.6.0 - July 31, 2023
Breaking Changes
- sslmode behavior has changed. To connect without ssl, set sslmode = disable. To connect using ssl, set sslmode to verify-ca, or verify-full. (#429)
- Drop support for python 3.7 (#dbt-core/7082)
- require latest version of redshift_connector driver (#492)
Features
- Add support for materialized views (#dbt-labs/dbt-core#6911)
- (#179)
- Standardize the _connection_keys and debug_query for
dbt debug
. (#PR754) - add merge as a new incremental strategy for redshift (#402)
- add dbt-redshift portion of dbt_clone functionality (#504)
- Enumerate implemented materialized view features via integration test flags and change
autorefresh
toauto_refresh
(#dbt-labs/dbt-core#6911)
Fixes
- Adding region as independent param in profiles (#419)
- Fix redshift_connector issue of timing out after 30s (#427)
- Update signature for execute method (#', #')
- translate psycopg2 sslmode to ssl and sslmode in redshift_connector (#429)
- Add a new connection param to reenable certain Redshift commands in macros. (#463)
- Escape
%
symbols in table/view/column comments (#441) - Use smaller default batch size for seeds (#347)
- Get autocommit on by default to restore old semantics users had relied on prior to 1.5. Add tests. (#425)
- remove depdency on postgres__list_relations_without_caching macro (#488)
- remove requirement for region param (#484)
- Remove dependent_projects argument from PartialProject call in unit tests (#7955)
- Fix regression in redshift-connector==2.0.912 (#518)
- Fixed unit test that broke following dbt clone work (#518)
- cast the port as an int (#518)
- hard pin dep on redshift_connector (#531, #532)
- re-enable query commenting (#536)
Under the Hood
- test constraint rendering of foreign key and unique constraints (#7417)
Dependencies
- Update pytest requirement from ~=7.2 to ~=7.3 (#414)
- Update pytest-xdist requirement from ~=3.2 to ~=3.3 (#449)
- Update types-requests requirement from ~=2.28 to ~=2.31 (#461)
- Update tox requirement from ~=4.5 to ~=4.6 (#481)
- Bump mypy from 1.2.0 to 1.4.0 (#503)
- Update pre-commit requirement from ~=2.21 to ~=3.3 (#426)
- Update pytest requirement from ~=7.3 to ~=7.4 (#507)
- Bump mypy from 1.4.0 to 1.4.1 (#508)
- Update pip-tools requirement from ~=6.13 to ~=6.14 (#517)