dbt-dremio

library1.10.1pypypiunverified

dbt-dremio is the Dremio adapter plugin for dbt (data build tool), enabling data teams to transform data directly within Dremio using dbt's SQL-based workflows. It allows users to define models, tests, and documentation, then execute them against Dremio for efficient data transformations. The current version is 1.10.0, with new releases typically aligning with dbt-core's major version updates, often every 1-3 months.

data

pip install dbt-dremio

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · DBT-DREMIO

dbt-dremio

datapythonv1.10.1

Install

10.6s avg

Import

—

Disk

118MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v1.10.1 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.910 runs

installs and imports cleanly · install 0.0s · import 0.000s · 114.9MB

glibc

py 3.10–3.910 runs

installs and imports cleanly · install 10.6s · import 0.000s · 115MB

118MB installed

● package 118MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

dbt-dremio adapter

✓ Configured in profiles.yml

dbt-dremio is a dbt adapter plugin and is not imported directly into Python scripts. It is loaded by dbt-core based on your profiles.yml configuration.

To get started with dbt-dremio, you need to configure your dbt `profiles.yml` to specify the connection details for your Dremio instance. Then, you can define your SQL models and run them using the dbt CLI. Ensure your dbt project is configured to use the Dremio profile. Remember to replace placeholders like `<your_dremio_host>`, `<your_dremio_username>`, `<your_dremio_password>`, and `<your_schema>` with your actual Dremio credentials and configuration.

# 1. Create a dbt project (if you don't have one) # dbt init my_dremio_project # 2. Configure your profiles.yml (typically at ~/.dbt/profiles.yml) # --- profiles.yml --- # my_dremio_profile: # target: dev # outputs: # dev: # type: dremio # host: <your_dremio_host> # e.g., localhost or cloud.dremio.com # port: 31010 # or 443 for Dremio Cloud # username: <your_dremio_username> # password: <your_dremio_password> # schema: <your_schema> # threads: 1 # db_name: Dremio # Can be 'Dremio' for Dremio Cloud, or your specific project ID # catalog: <your_catalog_name> # Optional, for Dremio Enterprise Catalogs (v1.9.0+) # disable_ssl_verification: true # Use with caution, for self-signed certificates # --- end profiles.yml --- # 3. Create a sample dbt model (e.g., models/my_first_model.sql) -- models/my_first_model.sql SELECT 1 as id, 'hello' as message # 4. Run dbt commands from your project directory # dbt debug # dbt run # dbt test

dbt --version

Debug

Known issues

breakingEach major release of dbt-dremio (e.g., v1.7.0, v1.8.0, v1.9.0, v1.10.0) is designed to be compatible with a specific major version of dbt-core. Upgrading dbt-core without upgrading dbt-dremio (or vice-versa) can lead to unexpected errors.

fix

Always check the dbt-dremio release notes for the compatible dbt-core version and upgrade both packages in tandem: `pip install --upgrade dbt-core dbt-dremio`.

affects: <=1.10.0

gotchaModel contracts and constraints, introduced in dbt-core v1.5.0, are 'stubbed' in dbt-dremio, meaning the adapter acknowledges the feature but does not fully support enforcement within Dremio. Attempting to use these features may not result in the expected behavior or error handling.

fix

Be aware that dbt model contracts and constraints might not be fully functional or enforced when using dbt-dremio. Consult the dbt-dremio documentation or GitHub issues for updates on future support.

affects: >=1.5.0

gotchaPrior to v1.5.1, the `create_view_as` macro included superfluous parentheses around views, which could lead to performance issues in more complex queries.

fix

Upgrade to dbt-dremio v1.5.1 or newer to benefit from performance improvements in view creation: `pip install --upgrade dbt-dremio`.

affects: <1.5.1

gotchaIn versions prior to v1.5.1, fetching model data was enabled by default, which could negatively impact performance. This behavior was changed in v1.5.1 to be `false` by default.

fix

Upgrade to dbt-dremio v1.5.1 or newer. If you must use an older version, investigate if explicitly disabling model data fetching is possible (though the official fix is to upgrade).

affects: <1.5.1

Upgrade

Version history

1.10.1latest on PyPI · released Jun 9, 2026

Audit

Dependencies

dbt-corerequiredThis package is a dbt adapter and requires a compatible version of dbt-core to function. Major versions of dbt-dremio are tied to specific dbt-core versions.

Agent activity

13 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/dremio/dbt-dremio ↗

packagehttps://pypi.org/project/dbt-dremio/ ↗

homepagehttps://www.getdbt.com ↗