sqlalchemy-dremio
A SQLAlchemy dialect for Dremio via the Flight interface.
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- 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 · maintenance · safety
Apache Software License (permissive) — Licensed under Apache Software License (permissive), which allows commercial and private use with minimal restrictions—suitable for most projects without legal concerns.
last release 2026-03-12 (155 days) · last repo commit 2026-03-12 · 30 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 283,784 downloads/mo, #8,071 on PyPI
Alternatives
Verify before relying
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')- 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).
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 on it.
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
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.
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.
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')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 | Not specified |
| Install friction | High. Source build required |
| Runtime dependencies | 2 packagesSQLAlchemypyarrow |
| Maintenance | Actively maintained 155 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 283,784 / month, #8,071 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseNatural Language :: EnglishProgramming Language :: Python :: 3Programming Language :: Python :: 3.7 |
Evidence: sqlalchemy_dremio-3.0.5.tar.gz
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlalchemy dremio dialect”
- sqlalchemy-dremioProvides a SQLAlchemy dialect to query Dremio data warehouses via…
- sqlalchemy-pgspiderProvides a SQLAlchemy dialect that enables connections to PGSpider…
- sqlalchemy-databricksProvides a SQLAlchemy dialect that connects to Databricks workspaces…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also iomete-sqlalchemy · teradatasqlalchemy · sqlalchemy-solr · sqlalchemy-drill · databricks-sqlalchemy · sqlalchemy-ibmi · sqlalchemy-jdbcapi · sqlalchemy-vertica-python · pybigquery · sqlalchemy-firebird