v1.4.3

1.4.3 is a patch version with the following bug fixes:

• Relax version constraint for dbt-core to major and minor version #99. This enables to install a compatible patched version of dbt-core whenever it is released without upgrading dbt-oracle

• Bugfix for #100

• Bugfix for #86

• Upgrade python driver to latest version 1.4.1

• Set connection id prefix to track dbt connections in cman logs

Thanks to @rkope99 for contributing to this release version

v1.5.3

1.5.3 is a patch version with the following bug fixes:

• Relax version constraint for dbt-core to major and minor version #99. This enables to install a compatible patched version of dbt-core whenever it is released without upgrading dbt-oracle

• Bugfix for Seed fails, if a column has no values

• Bugfix for Null values in column_id causes error in documentation generation

• Upgrade python driver to latest version 1.4.1

• Set connection id prefix to track dbt connections in cman logs

v1.6.0

1.6.0 is a minor release version with the following features and fixes:

• Relax version constraint for dbt-core to major and minor version #99
• Bugfix for Seed fails, if a column has no values
• Bugfix for Null values in column_id causes error in documentation generation
• Set connection id prefix to track dbt connections cman logs
• Support for dbt-core 1.6
  • Added support for materialized view
  • Dropped support for Python 3.7
  • New unit tests for materialized view

v1.5.2

This minor release has the following updates

• dbt-core upgraded to 1.5.3
• fixes sqlparse CVE GHSA-rrm6-wvj7-cwh2

v1.5.1

This release includes the following features and updates:

• Implemented support for Python models using Oracle's Autonomous Database Serverless (ADB-S)
  • User Defined Python function is run in an ADB-S spawned Python 3.10 runtime
    Import 3rd party Python packages installed in the default Python runtime
  • Access to Database session in the Python function
  • DataFrame read API to read TABLES, VIEWS and ad-hoc SELECT queries as DataFrames
  • DataFrame write API to write DataFrames as TABLES
  • Supports both table and incremental materialization
• dbt-core upgraded to 1.5.2
• oracledb upgraded to 1.3.2

v1.5.0

This is a minor release upgrade addressing #83 with the following updates

1. Model Contracts

   • Implemented data_type_code_to_name to convert Python oracledb driver return types to strings
   • Implemented oracle__get_empty_subquery_sql and oracle__get_empty_schema_sql to generate SQL to assert column spec equivalence
   • Updated macro create_table_as; calls to two macros that assert column spec equivalence and template out DDL containing column names, types, and constraints
   • Updated macro create_view_as added a call to the macro asserting column spec equivalence

2. Support the constraints data structure

   • Map constraint types to CONSTRAINT_SUPPORT
   • Override Adapter method render_column_constraint

3. Dependencies upgraded; dbt-core==v1.5.0 and oracledb=1.3.1

4. Test cases added to test constraints, simple seed, caching etc

v1.4.2

This release includes the following fixes and features

• Fixes #78 Flaky generic tests on multiple threads
• Adds support for parallel execution for incremental materialization #80. Thanks to @Mirko-T for the macro changes
• Upgrades dbt-core to v1.4.5

v1.4.1

Fixes pytz dependency reported in #75 and dbt-labs/dbt-core#7077

v1.4.0

This release includes the following features and fixes

• Added support for faster Python 3.11
• Added support for Incremental predicates which can be specified in incremental model configuration

     # this limits the scan of the existing table to the last 7 days of data
     incremental_predicates: ["DBT_INTERNAL_DEST.session_start > datediff(day, -7, current_date)"]
  

• Upgrade dbt-core dependency requirement to 1.4.1
• Replace deprecated exception functions defined in dbt-core v1.4.1
• Added more test cases to the dbt-oracle test suite

v1.3.2

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

• Upgraded dbt-core to 1.3.2

• Upgraded oracledb driver to 1.2.2 which fixes some bugs

• Added support for specifying CTAS degree of parallelism in dbt model config as requested in #65

• Added support for specifying table compression clause in dbt model config as requested in #65

• Bug fix for affected row count. Removed cursor.commit() which resets the affected rowcount. commit() is called by dbt-core after fetching the affected rowcount. Rowcount works for Thin driver mode. For Thick driver mode and old cx mode, rowcount is always 0 and a bug is logged with the driver team.

• Bug fix for using alias in dbt model config. dbt alias can be used as a work around for "Identifier too long" issue in older Oracle DB versions (11 for example). This was discussed in dbt labs Slack channel