Skip to main content

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