v1.3.1

This is a minor release upgrade with the following updates

• Tracing is enabled for database connection from dbt-oracle client. Session information can be found in V$SESSION

• Upgraded dependencies oracledb==1.2.1 and dbt-core==1.3.1

• Fix for issue #52 dbt snaphsots timestamp strategy where new records were being wrongly invalidated. The issue occurs only when update_dt, the column to track changes, is of DATE type. Casting DATE to VARCHAR during hash (dbt_scd_id) computation drops the time part. The fix is to CAST update_dt to TIMESTAMP to preserve the time part.

• Addresses feature request #55 Global temporary relation name includes milliseconds o$pt_<base_relation_identifier>_<%H%M%S%f>

v1.3.0

This is minor release upgrade with the following updates

• dbt-core and dbt-tests-adapter upgraded to the latest version v1.3.0
• Streamline incremental materialization as per new dbt requirements
• Consolidated timestamp based macros in dbt/include/oracle/util/timestamps.sql
• Added new macros for data types. For example, BigInt and Int in dbt/include/oracle/util/data_types.sql
• Added 11 new functional test cases. We now have a total of 71 test cases in the suite

Note: Python models are not yet supported in dbt-oracle==1.3.0

v1.2.1

Upgraded dependencies

• dbt-core to 1.2.2
• dbt-tests-adapter to 1.2.2
• oracledb to 1.1.1

v1.2.0

Following features and fixes are included in this release

• Dependencies dbt-core and dbt-tests-adapters are upgraded to the latest version 1.2.1
• Following cross-db-macros are implemented into adapter and tested accordingly

  String macros
   - concat
   - hash
   - position
   - right
   - length
   - replace
  
  String literal macros
   - escape_single_quotes
   - string_literal
  
  Cast
   - cast_bool_to_text
  
  Date and Time
   - dateadd
   - date_trunc
   - last_day
  
  Set 
   - except
   - intersect
  

• New basic tests BaseDocsGenerate and BaseDocsGenReferences are added to the test suite
• Managing of access grants is now supported and tested. You can use this with different materialization strategies i.e. tables, views, incremental materialization and snapshots.
• New parameters (retry_count and retry_wait) are supported in connection profile to support connection retries
• Fix for “where clause” config in generic tests
• Fix for dbt docs generation (catalog) where columns did not appear for some tables.

v1.1.2

This release includes the following features and fixes

• Better support quoting of database object names (relations and columns). This also fixes a bug raised by @ThoSap to allow the use of keywords and special characters in columns. For e.g. Airbyte requires columns like _AIRBYTE_AB_ID, _AIRBYTE_EMITTED_AT, _AIRBYTE_NORMALIZED_AT and DESC for internal purposes

• Fixes a bug to invalidate hard deletes during dbt snapshots.

• Upgraded dependencies to the following versions

  • dbt-core==1.1.2
  • dbt-adapter-tests==1.1.2
  • oracledb==1.0.3

v1.1.1

This release includes following features and fixes

• Addresses feature request #17 - dbt-oracle now supports python-oracledb which is the renamed, major release of Oracle's popular cx_Oracle interface.

  • It is strongly recommended to use this driver as it vastly simplifies dbt-oracle installation and makes it optional to install to Oracle Client Libraries. Python process directly communicates with the Oracle database.
  • To enable this new driver usage set the environment variable ORA_PYTHON_DRIVER_TYPE=thin

• Fixes #29 to include size, scale and precision in {{ column.data_type }}

• Addresses feature request #31 - To support config merge_update_columns in incremental materialization

v1.1.0

This release upgrades dbt-core requirement to the latest version v1.1.1 and addresses the feature request #19

• Migrated testing framework to the new fixtures based dbt-tests-adapter==1.1.1. As part of Continuous Integration (CI) we test against 25 test cases defined in the adapter suite. Prior to this release we tested with 12 test cases.
• Dropped support for Python 3.6
• Added support for Python 3.10
• Incremental materialization now supports a list of unique_keys. This translates to a comma separated AND predicates in the MERGE...ON statement
• Incremental materialization now supports on_schema_change configuration to sync the source and target schemas. Following values can be used ['sync_all_columns', 'append_new_columns', 'fail', 'ignore']
• pytest.ini configuration file now simplifies unit test configuration
• Fixes bug #26 raised by AlexMorti

v1.0.4

Bumped dbt-core version to v1.0.8 which includes a (critical support) security fix for rendering of secret env vars

v1.0.3

dbt-oracle v1.0.3 is a maintenance release with the following fixes and features

1. Clean up O$PT temporary tables which are created in dbt snapshots and incremental materialization

   • Fixes #12 raised by AlexMorti

2. Support to create dbt models in custom schema other than the target schema.

   • Macros in adapter.sql use {schema}.{table} instead of just {table} to refer to the relation wherever possible

   • Fixes #14

   • Fixes #2

   • Addresses issues raised in PR #15 by @algol68

3. dbt-oracle is now integrated with dbt_constraints

   • Fixes #5 raised by danflippo

4. Includes a change by @ThoSap to remove whitespace control characters from MERGE jinja macro used in incremental materialization

5. Simplify view creation using CREATE or REPLACE view clause

6. The metadata retrieved using list_relations_without_caching, get_columns_in_a_relation and catalog.sql are no longer converted to lowercase. We keep them to default UPPERCASE as returned by the Database

7. _make_match_kwargs() is overridden in oracle/impl.py to make the match kwargs uppercase

8. quote_seed_column() is overridden in oracle/impl.py to make quote_columns=False as default value

9. Simplified README.md. Most of the documentation is moved under dbt docs Oracle Profile

10. The sample dbt_adbs_test_project now includes a model with custom schema and generate_schema_name macro to decide how the dbt schema should be resolved.

v1.0.2

This is a maintenance release in which dbt-core required version is updated to v1.0.7

• dbt-core v1.0.7 lowers networkx dependency range due to new version's breaking change (dbt-labs/dbt-core#5254, dbt-labs/dbt-core#5280)