Skip to content

v1.0.3

Compare
Choose a tag to compare
@aosingh aosingh released this 16 Jun 01:33
· 261 commits to main since this release

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

  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

  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.