Oracle Profile

Community contributed plugin

This is a Community Contributed plugin for dbt. If you're interested in contributing, check out the source code dbt-oracle

Overview of dbt-oracle

Status: Community Contributed Author: Vitor Avancini Source Code: https://github.com/techindicium/dbt-oracle

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
pass: oracle
port: 1521
dbname: [dbname]
schema: [schema]
threads: 4