A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.
pip install sqlalchemy_dremio
conda install sqlalchemy-dremio
To install from source:
python setup.py install
Connection String example:
Dremio Software:
dremio+flight://user:password@host:port/dremio
Dremio Cloud:
dremio+flight://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:
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.
- 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