v1.7.5

This release includes the following updates:

• Upgrade oracledb driver to v2.2.0
• Fix Oracle error: ORA-14452: attempt to create, alter or drop an index on temporary table already in use while using constraints with Incremental materialization. Issue discussed and fix verified in this slack thread : https://getdbt.slack.com/archives/C01PWH4TXLY/p1712669363630279

v1.7.4

This release includes the following updates:

• Python oracledb driver upgraded to 2.1.2
• Fixes #139
• Removed cx_Oracle from 3rd party dependency list
• Addresses request to install dbt-oracle on ARM machines

v1.7.3

This release version has the following upgrades and bug fixes

• Added support for Python 3.12
• Implemented delete+insert incremental strategy - feature request #128
• Support for new partition_config in table and incremental materialization. This will add the partitioning clause in the CTAS DDL statement generated by dbt-oracle.

partition_config={"clause": "PARTITION BY HASH(PROD_NAME) PARTITIONS 4"}

• oracledb driver upgraded to 2.1.0
• minor readme updates

v1.6.3

This release version has the following upgrades and bug fixes

• Fix for Bug #130 : Quoting Identifier True and Persist docs
• Fix for Bug #129 : table materialization fails when another MV with the same name exists in database
• Fix for dbt contracts using CLOB datatype (e.g. Kafka messages)
• Python Driver upgraded to oracledb==2.0.1

Contributors: @amoghparab1805

v1.7.2

This release version has the following upgrades and bug fixes

• Fix for Bug #130 : Quoting Identifier True and Persist docs
• Fix for Bug #129 : table materialization fails when another MV with the same name exists in database
• Fix for dbt contracts using CLOB datatype (e.g. Kafka messages)
• Python Driver upgraded to oracledb==2.0.1

v1.7.1

This release version has the following upgrades and bug fixes

• Python driver oracledb upgraded to version 2.0.0
• Bug fix for #125 - Generated catalog.json is empty
• Bug fix to handle full_refresh configuration correctly

v1.7.0

This is a minor version upgrade with the following features and fixes

• dbt-core upgraded to ~1.7.x
• oracledb driver requirement upgraded to 1.4.2
• Default driver mode is thin i.e. ORA_PYTHON_DRIVER_TYPE=thin. If you have hardcoded ORA_PYTHON_DRIVER_TYPE=cx, please remove it
• Use dbt-oracle version in connection prefix
• Fix regressions in test suites due to dbt-core 1.7 API changes
• Materialized View refactoring
• Pass session information from dbt job profile to OML client
• Error handling in while executing Python UDF in ADB-S
• Removed print statement in case of an exception in Python UDF
• Close Database session after Python UDF completion
• Added support to check source freshness
• Added support for 2 new utils date_spline(datepart, start, end) and generate_series(upperbound)
• Added support for dbt show --limit command
• New test cases

v1.4.4

This is a maintenance release with the following updates:

• python driver oracledb upgraded to 1.4.2

• Pass down session info from dbt job profile to v$session

Contributors : @amoghparab1805

v1.6.2

This is a maintenance release with the following updates:

• Include dbt version in oracledb's connection id prefix
• Pass down session info from dbt job profile to OML python job
• Refactoring OML Python code generation to handle exceptions
• OML client's close database connection on exit

v1.5.5

This is a maintenance release with the following updates:

• Include dbt version in oracledb's connection id prefix
• Pass down session info from dbt job profile to OML python job
• Refactoring OML Python code generation to handle exceptions
• OML client's close database connection on exit