An Oracle DBT Adapater
Project description
Oracle DBT
Installation
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.
Installing:
pip install dbt-oracle=0.1.1
Testing
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
https://github.com/vitoravancini/dbt-integration-tests
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 wellcome.
History
0.1.0 (2020-06-02)
First release on PyPI.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for dbt_oracle-0.1.3-py2.py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | b3f9cf46945a110700ff2bfa58d66dce8f01282b5b2b51ae48e7aaf123b3e7f8 |
|
| MD5 | 2a4cb40d344dcddbef8528967838155a |
|
| BLAKE2b-256 | 33d0983a1a4cac3c3e083014478ad5406bfc30eb3ec59a8ff979c6ee33791f24 |
