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: Core version: v0.16.0 and newer

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