An Oracle DBT Adapater
You need the oracle database client installed in your system in order for this to work,
here(https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html) you can find the cx_oracle python driver installation instructions.
this(https://gist.github.com/tcnksm/7316877) gist is a useful resource for installing in ubuntu. It’s an onld link for ubuntu 12 but it still works at least for ubuntu 18.
pip install dbt-oracle=0.1.1
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 \ epiclabs/docker-oracle-xe-11g
Install the project locally
python setup.py 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: https://github.com/fishtown-analytics/dbt-integration-tests
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:
This is a new project and any contribuitions are wellcome.
- First release on PyPI.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size dbt_oracle-0.1.3-py2.py3-none-any.whl (9.8 kB)||File type Wheel||Python version py2.py3||Upload date||Hashes View|
|Filename, size dbt-oracle-0.1.3.tar.gz (10.4 kB)||File type Source||Python version None||Upload date||Hashes View|
Hashes for dbt_oracle-0.1.3-py2.py3-none-any.whl