A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.

• Installation
• Usage
• Testing
• Superset Integration

pip install sqlalchemy_dremio

conda install sqlalchemy-dremio

To install from source: python setup.py install

Connection String example:

Dremio Software:

dremio+flight:https://user:password@host:port/dremio

Dremio Cloud:

dremio+flight:https://data.dremio.cloud:443/?Token=<TOKEN>UseEncryption=true&disableCertificateVerification=true

Options:

Schema - (Optional) The schema to use

TLS:

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

WLM:

https://docs.dremio.com/software/advanced-administration/workload-management/#query-tagging--direct-routing-configuration

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

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

• 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