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: Github
Core version: v0.16.0 and newer
dbt Cloud: Not Supported
dbt Slack channel Link to channel

dbt-oracle stars

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