---
id: sqlalchemy-dremio
version: "3.0.5"
license: Apache Software License
license_treatment: permissive
maintenance: active
---

# sqlalchemy-dremio — A SQLAlchemy dialect for Dremio via the Flight interface.

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

## What it is and what it does

sqlalchemy-dremio is a SQLAlchemy dialect that bridges Python applications to Dremio, a data warehouse platform. It translates SQLAlchemy queries into Dremio-compatible operations, allowing you to use standard SQL and SQLAlchemy's ORM or Core API to interact with Dremio data without learning Dremio-specific query syntax. The dialect supports both Flight (the modern Arrow-based protocol) and legacy ODBC connections, with optional TLS encryption and workload management (WLM) routing for enterprise deployments.

The package depends on SQLAlchemy for the dialect framework and pyarrow for Flight protocol support. It is actively maintained, marked as production-stable, and integrates with tools like Apache Superset for business intelligence workflows. Connection strings are configurable with options for schema selection, encryption, certificate verification, and query routing.

Use it for:

- Build Python data pipelines that query Dremio using SQLAlchemy ORM, avoiding direct Dremio SQL syntax.
- Integrate Dremio as a data source in Superset dashboards via the Flight interface.
- Connect Jupyter notebooks or analytics scripts to Dremio for exploratory data analysis.
- Route queries to specific Dremio workload management queues or engines using routing tags.
- Establish encrypted TLS connections to Dremio Cloud from Python applications.

## Worth the install?

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

Provides a SQLAlchemy dialect to query Dremio data warehouses via Flight and ODBC interfaces, enabling SQL-based access to Dremio within Python applications.

Yes, if you need SQLAlchemy-based access to Dremio. The package is production-stable, actively maintained, has no known vulnerabilities, and carries a permissive license. The high install friction (two non-trivial dependencies) is typical for database dialects and worth the cost if Dremio is your target warehouse. Verify Python version compatibility for your environment before installing.

## Install

pip install sqlalchemy-dremio
uv add sqlalchemy-dremio
poetry add sqlalchemy-dremio

## Installing sqlalchemy-dremio

Before you install: High install friction due to two runtime dependencies (SQLAlchemy and pyarrow). Package is actively maintained with a recent release and no known vulnerabilities, but the dependency footprint may add complexity to your environment setup.

License in practice: Licensed under Apache Software License (permissive), which allows commercial and private use with minimal restrictions—suitable for most projects without legal concerns.

Quickstart:

pip install sqlalchemy_dremio

from sqlalchemy import create_engine

engine = create_engine('dremio+flight://user:password@host:port/dremio')
with engine.connect() as conn:
    result = conn.execute('SELECT * FROM table')

Requires a running Dremio instance (Software or Cloud) accessible at the specified host and port; Flight or ODBC connectivity must be enabled on the Dremio side.

Verify before relying:

- Whether pyarrow version constraints or SQLAlchemy version compatibility limits exist beyond what the fact sheet states.
- Performance characteristics when querying large datasets through the Flight interface.
- Support status for Python versions beyond 3.7 (classifiers list only 3.7 explicitly).

## Package facts

- License: Apache Software License (permissive)
- Python support: unspecified
- Install friction: high
- Maintenance: active
- Downloads: 283.8K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy dremio dialect, dremio flight connection, query dremio with sql, dremio odbc sqlalchemy, dremio data warehouse python, sqlalchemy dremio integration, database-connector, data-warehouse

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