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.

dbt-teradata v1.8.0

dbt-teradata 1.8.0a

Features

• dbt-teradata is now compatible with dbt-core 1.8.x
• dbt-teradata adapter has been decoupled from dbt-core and is now compatible with dbt-adapters >= 1.2.1, dbt-common >= 1.3.0
• Unit test feature of dbt 1.8 is now supported in dbt-teradata
• Added support for --empty flag for dry run

Fixes

• Fixed - Collisions in dbt_scd_id while calculating snapshots (#160)

Docs

Under the hood

• Changes in workflow files for better release activity

dbt-teradata v1.7.3

dbt-teradata 1.7.3a

Features

• dbt-teradata 1.7.3 is now compatible with dbt-core 1.7.16
• Adding 'valid_history' incremental materialization strategy (early access)
• Implementation of query_band support in dbt-teradata

Fixes

• Fixed the issue with expanding the size of Unicode varchars.
  • #153
• Fixed the issue where the 'TeradataCursor' object lacked the 'activityname' attribute.
  • #155
• Fixed the model encountering the "Syntax error: Multiple definitions for WITH" error.
  • #161

dbt-teradata v1.7.2

dbt-teradata 1.7.2a

Features

• dbt-teradata 1.7.2 is now compatible with dbt-core 1.7.11
• Adding the native JSON datatype support
  • #142

Fixes

• Fixed the issue with rendering of index creation from configs
  • #144
• Fixed the issue with run_result.json has rows_affected = 0 always when data are inserted into target table, and code shows success instead of insert or update
  • #145

Under the hood

• No security vulnerabilities reported in the Snyk report

dbt-teradata v1.7.1

dbt-teradata 1.7.1a

Features

• Model contracts are now supported with dbt-teradata v1.7.1 and onwards
• Addition of Tera Mode in dbt-teradata

  IMPORTANT NOTE: This is an initial implementation of the TERA transaction mode and may not support some use cases. We strongly advise validating all records or transformations utilizing this mode to preempt any potential anomalies or errors.

Fixes

• Fixed the bug related to missing keyword 'raise' in one of the exception handling
  #133
• Fixed the Issue: Incremental Materialization : Merge not working when update does single column
  #120

Docs

Under the hood

• Migrated CI pipeline to environments dynamically provisioned in ClearScape Analytics Experience (https://clearscape.teradata.com/)

dbt-teradata v1.7.0

dbt-teradata 1.7.0a

Features

• dbt-teradata 1.7.0 is now compatible with dbt-core 1.7.3

• New capability support structure for adapters to include
  TableLastModifiedMetadata and SchemaMetadataByRelations capabilities

• Catalog fetch performance improvements
  dbt-labs/dbt-core#8521

• Added Metadata freshness check feature
  dbt-labs/dbt-core#8704

• Migrated date_spine() and dependent macros
  dbt-labs/dbt-core#8172

Fixes

• Fixed issue related to dbt show with limit option
  #125

Docs

• Stubbed model contracts support
• materialized_view is not yet supported

Under the hood

• Addition of some more adapter zone testcases