Skip to main content

An Oracle DBT Adapater

Project description

Oracle DBT

https://img.shields.io/pypi/v/dbt-oracle.svg

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.

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.3
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

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate 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