dbt-dremio

What it is and what it does

dbt-dremio is a plugin that integrates Dremio with dbt, allowing data analysts and engineers to apply software engineering practices to data transformation. It enables you to organize, cleanse, denormalize, filter, rename, and pre-aggregate raw data in Dremio using dbt's declarative SQL-based workflow. The adapter works with both Dremio Cloud and Dremio Software (versions 22.0 and later), and version 1.10.1 is compatible with dbt-core 1.10.*.

The package builds on dbt-core, dbt-common, dbt-adapters, and requests to provide Dremio-specific materializations and connection handling. It's maintained by Dremio and has been actively developed since its initial release in 2020, with community contribution pathways documented in the repository.

Use it for:

• Transform raw data in Dremio using version-controlled SQL models and dbt's testing framework
• Automate data pipeline orchestration with dbt's scheduling and dependency management in Dremio environments
• Organize and denormalize data warehouse tables using dbt materializations tailored for Dremio
• Integrate Dremio data transformation into existing dbt projects and CI/CD workflows

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

dbt-dremio is a dbt adapter that enables data transformation workflows in Dremio Cloud and Dremio Software (versions 22.0 and later) using dbt's ELT practices.

Yes. dbt-dremio is actively maintained by Dremio, has no known vulnerabilities, low install friction, and permissive licensing. Install it if you use Dremio (Cloud or Software 22.0+) and want to adopt dbt for data transformation. Verify that your Dremio version meets the 22.0+ requirement before proceeding.

Install

dbt-dremio on PyPI

pip install dbt-dremio

uv add dbt-dremio

poetry add dbt-dremio

Installing dbt-dremio

Before you install

Low install friction with a pure-Python wheel. Actively maintained by Dremio with a recent release (66 days ago) and ongoing repository activity. Requires dbt-core 1.10.* and three other dbt packages as runtime dependencies.

License in practice

Apache Software License 2.0 is permissive; you can use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.

Quickstart

pip install dbt-dremio

import dbt.adapters.dremio
# Configure dbt_project.yml with Dremio profile and run dbt commands

Requires dbt-core >= 1.10.* and a configured Dremio connection profile in dbt_project.yml or profiles.yml

Verify before relying

• Whether version 1.10.1 supports Dremio Software versions beyond 22.0
• Performance characteristics or known limitations when working with large datasets in Dremio

Package facts

Evidence: dbt_dremio-1.10.1-py3-none-any.whl

Tags

More Database packages