sqlalchemy-dremio

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

sqlalchemy-dremio on PyPI

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

Evidence: sqlalchemy_dremio-3.0.5.tar.gz

Keywords: sqlalchemy_dremio

Tags

More Front-Ends packages