dbt-redshift v1.6.0

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 to auto_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)

Contributors

• @jiezhen-chen (#429, #179, #402, #427, #429, #518)
• @nssalian (#419, #', #')

dbt-redshift v1.5.9

dbt-redshift 1.5.9 - July 31, 2023

Fixes

• re-enable query commenting (#536)

dbt-redshift v1.6.0rc1

dbt-redshift 1.6.0-rc1 - July 17, 2023

Features

• (#179)
• 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 to auto_refresh (#dbt-labs/dbt-core#6911)

Fixes

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

Dependencies

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

Contributors

• @jiezhen-chen (#179, #402, #518)

dbt-redshift v1.5.8

dbt-redshift 1.5.8 - July 13, 2023

Fixes

• cast the port as an int (#518)
• hard pin dep on redshift_connector (#531, #532)

Contributors

• @jiezhen-chen (#518)

dbt-redshift v1.5.7

dbt-redshift 1.5.7 - July 06, 2023

Fixes

• Fix regression in redshift-connector==2.0.912 (#518)

dbt-redshift v1.6.0b5

dbt-redshift 1.6.0-b5 - June 23, 2023

Features

• Add support for materialized views (#dbt-labs/dbt-core#6911)

dbt-redshift v1.5.6

dbt-redshift 1.5.6 - June 22, 2023

Breaking Changes

• Drop support for python 3.7 (#dbt-core/7082)

dbt-redshift v1.6.0b4

dbt-redshift 1.6.0-b4 - June 16, 2023

Breaking Changes

• require latest version of redshift_connector driver (#492)

Fixes

• remove requirement for region param (#484)

Contributors

• @dataders (#492)

dbt-redshift v1.5.5

dbt-redshift 1.5.5 - June 15, 2023

Breaking Changes

• require latest version of redshift_connector driver (#492)

Fixes

• remove requirement for region param (#484)

Under the Hood

• test constraint rendering of foreign key and unique constraints (#7417)

Contributors

• @dataders (#492)

dbt-redshift v1.6.0b3

dbt-redshift 1.6.0-b3 - June 09, 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)

Features

• Standardize the _connection_keys and debug_query for dbt debug. (#PR754)

Fixes

• translate psycopg2 sslmode to ssl and sslmode in redshift_connector (#429)
• 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)

Under the Hood

• test constraint rendering of foreign key and unique constraints (#7417)

Contributors

• @jiezhen-chen (#429, #429)