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)

v1.0.1

Release v1.0.1 is a maintenance release.

• Fixes bug #4 Renaming the old_relation does not work in Oracle 12c+ when using DBT table materialization with missing database name in profiles.yml
• Continuous Integration Support using GitHub Actions to run dbt adapter test suite against an Oracle Express (XE) database instance. The test suite is run for Python 3.6, 3.7, 3.8 and 3.9
• Oracle Contributor Agreement (OCA) bot integration by Oracle GitHub Organization (OGHO). For every PR raised this will verify if the external contributors have signed the OCA or not.

v1.0.0

• Python versions
  • Python 3.6, 3.7, 3.8 and 3.9 are supported.
  • Removed support for Python 3.5. Python 3.5 reached end-of-life in September 2020. Previous releases of dbt-oracle supported Python 3.5
• Enhancements
  • Following dependencies are upgraded
    • cx_Oracle v8.3.0
    • dbt-core v1.0.6
  • Following development dependencies are removed
    • watchdog
    • bumpversion
    • flake8
    • docutils
    • Sphinx
  • Added conditional dependency on dataclasses package for Python 3.6. dataclasses package was included in the standard library from Python 3.7
  • Fallback to dbt-core v0.21.1 for Python 3.6
  • Added support to connect to a shard
  • Added support for Database Resident Connection Pooling (DRCP)
  • Remove hardcoded configurations. Configurations should be specified using environment variables and follow the prefix pattern DBT_ORACLE_*
  • PEP-517 and PEP-518 compliant build system.
    • Introduced pyproject.toml file to specify build dependencies.
    • Modified setup.py and setup.cfg to define dynamic and static metadata respectively.
  • tox automation to test the adapter plugin for Python versions 3.6, 3.7, 3.8 and 3.9
• Fixes
  • Fix: ORA-12537 for OracleConnectionMethod.HOST
  • Fix: Generic tests and singular tests. Introduced macro oracle__get_test_sql and changed macro signatures in schema_tests.sql
  • Fix: tests/oracle.dbtspec::test_dbt_snapshot_strategy_check_cols - ORA-00942: table or view does not exist
  • Fix: tests/oracle.dbtspec::test_dbt_ephemeral_data_tests - ORA-32034: unsupported use of WITH clause
  • Fix: ORA-00933: SQL command not properly ended raised in techindicium/dbt-oracle#26
  • Fix: Return an object of type AdapterResponse in adapter's get_response(cls, cursor) method. Cursor's rowcount attribute is included in the AdapterResponse
  • Commented the method list_relations_without_caching in dbt/adapters/oracle/impl.py
• Integration Testing with Autonomous Database Service (ADBS)
  • The test project dbt_adbs_test_project can be used to perform integration testing with Oracle's Autonomous Database Cloud Service. Following features are tested