---
id: dbt-oracle
version: "1.12.0"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# dbt-oracle — dbt (data build tool) adapter for Oracle Autonomous Database

License: permissive · Maintenance: active · Downloads: 91.3K/mo

## What it is and what it does

dbt-oracle bridges dbt (a popular SQL transformation framework) and Oracle Autonomous Database, letting you write modular SQL transformations, manage dependencies, and orchestrate data pipelines in Oracle. It's maintained by Oracle itself as of version 1.0.0 and integrates with the dbt ecosystem via standard adapter interfaces.

You install it alongside dbt-core and configure a connection profile pointing to your Oracle instance. Once set up, you write dbt models as SQL files, define tests and documentation, and run dbt commands to build and validate your data transformations directly in Oracle. The adapter handles Oracle-specific SQL generation and connection management.

Use it for:

- Build modular, version-controlled SQL transformation pipelines in Oracle Autonomous Database using dbt's standard workflow.
- Orchestrate complex multi-step data workflows with dependency management and incremental builds on Oracle.
- Integrate Oracle data transformations into a dbt-based analytics stack alongside other dbt adapters.
- Document and test data models in Oracle with dbt's built-in testing and documentation frameworks.
- Migrate existing dbt projects from other databases to Oracle Autonomous Database.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

dbt-oracle is a dbt adapter that enables data transformation and orchestration workflows on Oracle Autonomous Database using dbt's SQL-based modeling framework.

Yes. dbt-oracle is actively maintained by Oracle, carries no known vulnerabilities, has low install friction, and is licensed permissively. Install it if you use dbt and need to run transformations on Oracle Autonomous Database. The recent release cadence and active repository signal ongoing support.

## Install

pip install dbt-oracle
uv add dbt-oracle
poetry add dbt-oracle

## Installing dbt-oracle

Before you install: Low friction install with a recent release (8 days old) and active maintenance. The package depends on dbt-core, dbt-adapters, dbt-common, and oracledb—all standard dbt ecosystem components. Repository is actively maintained by Oracle with regular commits.

License in practice: Licensed under Apache-2.0 (permissive), allowing use in commercial and private projects with minimal restrictions. You must retain the license notice but face no copyleft obligations.

Quickstart:

pip install dbt-oracle

In your dbt project's profiles.yml:
my-oracle-db:
  target: dev
  outputs:
    dev:
      type: oracle
      host: [hostname]
      user: [username]
      pass: [password]
      database: [database]
      schema: [schema]
      threads: 4

Requires Python 3.10 or later. An Oracle Autonomous Database instance and valid credentials are needed to connect.

Verify before relying:

- Specific dbt version compatibility range (fact sheet lists dbt-core as a runtime dependency but not its version constraint).
- Whether the adapter supports all dbt features or has known limitations for Oracle-specific SQL dialects.
- Performance characteristics and scalability limits for large transformation workloads.

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 91.3K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dbt oracle adapter, oracle autonomous database dbt, dbt data transformation oracle, oracle sql dbt integration, dbt oracle warehouse, oracle database dbt connector, dbt oracle etl, dbt-adapter, data-transformation, oracle

[View on SkillFed](https://skillfed.io/packages/dbt-oracle) · [View on PyPI](https://pypi.org/project/dbt-oracle/)