SQLAlchemy Dremio

A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.

• Installation
• Usage
• Testing
• Superset Integration

Installation

pip install sqlalchemy_dremio

To install from source: python setup.py install

Usage

Connection String example: dremio+flight://user:password@host:port/dremio

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

3.0.3

• Add back missing routing_engine property.

3.0.2

• Add implementations of has_table and get_view_names.

3.0.1

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