dbt-oracle

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 on this page — 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

dbt-oracle on PyPI

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

Evidence: dbt_oracle-1.12.0-py3-none-any.whl

Keywords: Oracle, dbt

Tags

More Build Tools packages