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:

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
target: dev
type: oracle
host: localhost
user: system
pass: oracle
port: 1521
dbname: [dbname]
schema: [schema]
threads: 4