---
id: dbt-dremio
version: "1.10.1"
license: Apache Software License 2.0 (http://www.apache.org/licenses/LICENSE-2.0)
license_treatment: permissive
maintenance: active
---

# dbt-dremio — The Dremio adapter plugin for dbt

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

## 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 above — 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

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

- License: Apache Software License 2.0 (http://www.apache.org/licenses/LICENSE-2.0) (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 178.1K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dbt adapter for dremio, dremio data transformation, dbt warehouse plugin, dremio elt pipeline, dbt dremio integration, dbt-adapter, data-warehouse, etl-elt

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