dbt-teradata v1.10.1

dbt-teradata 1.10.1a

Features

Fixes

• Right truncation of string data for UDF/XSP/UDM udf_md5 during snapshot execution 229

• dbt snapshot command leading to syntax error in DB version 20.00 or greater

Docs

Under the hood

dbt-teradata v1.10.0

dbt-teradata 1.10.0a

Features

• Upgraded dbt-teradata adapter to support dbt-core v1.10 (Python 3.13, new flags, and deprecated function replacements).

Fixes

• Fixed unit test failures by updating dbt-teradata adapter to align with new macros and changes introduced in dbt-core.
• Fixed column misalignment in snapshot helpers.sql by ensuring consistent column ordering across union-all statements.
  • 221
• Fix for teradata__get_columns_in_relation macro do not respect fallback_schema
  • 218
  • 220
• Snapshot timestamp strategy ignoring user-defined hashing function set via snapshot_hash_udf config.
  • 222

Docs

Under the hood

• Changed to config name from 'fallback_schema' to 'temporary_metadata_generation_schema'

dbt-teradata v1.9.3

dbt-teradata 1.9.3a

Features

• Added support for dbt-external-tables 146

Fixes

• Added fallback_schema for metadata table creation when QVCI is disabled, also fixed the concurrency issues related to it
  • 212
  • 213

Docs

• Addition of documentation for usage of dbt-external-tables and fallback_schema to Readme.

Under the hood

• Enhanced exception messages with more information for better debugging.

dbt-teradata v1.9.2

dbt-teradata 1.9.2a

Features

• Added support for http proxy connection parameters 211

Fixes

Docs

Under the hood

dbt-teradata v1.9.1

dbt-teradata 1.9.1a

Features

• Addition of Microbatch incremental strategy(Beta) 203

Fixes

Docs

Under the hood

• Addition of functional testscases for Microbatch strategy

dbt-teradata v1.9.0

dbt-teradata 1.9.0a

Features

• Addition of new Snapshot features with dbt-teradata v1.9 (#207):
  • Enable setting a datetime value for dbt_valid_to for current records instead of NULL
  • Enable hard_deletes config to add a metadata column if a record has been deleted
  • Allow customizing names of metadata fields
  • Enable unique_key as a list

Fixes

Fixes the exception handling on the valid_history incremental strategy

Docs

Under the hood

• Addition of testcases for Snapshot

dbt-teradata v1.8.3

dbt-teradata 1.8.3a

Features

• Removed dependency on QVCI for retrieving column information of views.

Fixes

Docs

Updated Readme for

• Deleted the content related to enabling QVCI and the use_qvci flag.
• Included a note on unique alias requirements for CTEs and subqueries in unit testing

Under the hood

dbt-teradata v1.8.2a1

dbt-teradata 1.8.2a1a

Features

Fixes

Docs

Under the hood

dbt-teradata v1.8.2

dbt-teradata 1.8.2a

Features

• Addition of md5_udf variable for custom hash macro configuration
  • (Teradata/dbt-teradata-utils#2)
• Full support for valid_history incremental strategy
• Remove support and testing for Python 3.8, which is now EOL

Fixes

• Adapter does not resolve dates correctly in unit testing
• Snapshots fail on structure changes
  • (#192)

Docs

Updated Readme for

• md5_udf variable - for custom hash macro configuration
• valid_history incremental strategy
• unit testing support

Under the hood

• Test project for valid_history incremental strategy
• Addition of more function tests for better coverage
• Change in workflow file for testing md5_udf variable

dbt-teradata v1.8.1

dbt-teradata 1.8.1a

Features

• dbt-teradata is now fully compatible with Python 3.12.
• Added support for browser-based Single Sign-On (SSO) authentication when connecting to SSO-enabled Teradata databases. Please refer to the README for more details.

Fixes

• Resolved an issue with the 'show' command.
  • dbt-labs/dbt-adapters#249
• Fixed a TypeError in TeradataAdapter.get_catalog() where it incorrectly took three arguments instead of two.
  • #180
• Corrected exception handling for failed database connections.
  • #183

Docs

• Updated the README to include additional Teradata profile fields and threads options.

Under the hood

• Expanded test coverage for snapshots.
• Verified the compatibility of dbt's threads feature with dbt-teradata.