Skip to main content

An Oracle DBT Adapter

Project description

Oracle DBT


You need the oracle database client installed in your system in order for this to work, here ( you can find the cx_oracle python driver installation instructions.

This ( gist is also a useful resource for installing the client in Ubuntu. It’s an old link for Ubuntu 12 but it still works at least for ubuntu 18.


pip install dbt-oracle=0.1.3

Configure your profile

   target: dev
         type: oracle
         host: localhost
         user: system
         pass: oracle
         port: 1521
         dbname: xe
         schema: system
         threads: 4

Supported Features


  • table: OK
  • view: OK
  • incremental: not OK
  • ephemeral: not tested





Custom schemas

Not tested


Not tested

Testing & documentation

  • Schema tests OK
  • Relationship testes Not OK
  • SQL Tests OK
  • Docs generate Not OK


Not OK


There is a dummy dbt project called dbt_test_project for testing some things that the official dbt integration tests do not cover. For running it first start an oracle database instance:

docker run \
--name dbt-oracle-db \
-d \
-p 1521:1521 \

Install the project locally

python install

then run dbt seed and run (theres is a profile file compatible with oracle 11g docker defaults at the test dir)

cd dbt_test_project
dbt seed --profiles-dir ./
dbt run --profiles-dir ./

DBT Integration Tests

DBT team provides a project with some integration tests that can programatically assert that the plugin provides all the DBT features.

you can find it here:

Currently we are using a fork of this project to apadpt some parts of it for running with oracle db

The specific changes are specified at the project’s readme

for running it against dbt-oracle adapter one can run:

make test-dbt-integration

Final Notes

This is a new project and any contribuitions are welcome.



First Version


0.1.0 (2020-06-02)

  • First release on PyPI.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for dbt-oracle, version 0.1.4
Filename, size File type Python version Upload date Hashes
Filename, size dbt_oracle-0.1.4-py2.py3-none-any.whl (11.7 kB) File type Wheel Python version py2.py3 Upload date Hashes View
Filename, size dbt-oracle-0.1.4.tar.gz (10.9 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page