Skip to main content

A SQLAlchemy dialect for Dremio via the Flight interface.

Project description

SQLAlchemy Dremio

PyPI Build

A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.


From pip:

pip install sqlalchemy_dremio

Or from conda:

conda install sqlalchemy-dremio

To install from source: python install


Connection String example:

Dremio Software:


Dremio Cloud:



Schema - (Optional) The schema to use


UseEncryption=true|false - (Optional) Enables TLS connection. Must be enabled on Dremio to use it. DisableCertificateVerification=true|false - (Optional) Disables certificate verirication.


routing_queue - (Optional) The queue in which queries should run routing_tag - (Optonal) Routing tag to use. routing_engine - (Optional) The engine in which the queries should run

Superset Integration

The ODBC connection to superset is now deprecated. Please update sqlalchemy_dremio to 3.0.2 to use the flight connection.

Release Notes


  • Addressing issue #34 and #37: Add driver name to dialects


  • Add back missing routing_engine property.


  • Add implementations of has_table and get_view_names.


  • Made connection string property keys case-insensitive
  • Fix incorrect lookup of the token property
  • Fix incorrect lookup of the DisableCertificateVerification property

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlalchemy_dremio-3.0.4.tar.gz (16.1 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page