Oracle Profile

Community plugin

Some core functionality may be limited. If you're interested in contributing, check out the source code for each repository listed below.

Overview of dbt-oracle

Maintained by: Community Author: Vitor Avancini Source: https://github.com/techindicium/dbt-oracle Core version: v0.16.0 and newer

Easiest install is to use pip:

pip install dbt-oracle

You will need Oracle client driver installed. Check this link for the installation guide for your operating system

Connecting to Oracle with dbt-oracle

User / password authentication

Configure your dbt profile for using Oracle Authentication:

Oracle Authentication

profiles.yml

dbt_oracle:
   target: dev
   outputs:
      dev:
         type: oracle
         host: localhost
         user: system
         password: oracle
         port: 1521
         dbname: [dbname]
         schema: [schema]
         threads: 4