A SQLAlchemy dialect for Dremio via the ODBC and Flight interface.
Project description
SQLAlchemy Dremio
A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.
Installation
pip install sqlalchemy_dremio
Pre-Requisites
Mac OS X:
- Unix ODBC: (brew install unixodbc)
- Dremio ODBC Driver (https://download.dremio.com/odbc-driver/DremioODBC-LATEST.dmg)
CentOS/RHEL:
- Unix ODBC (sudo apt-get install -y unixODBC unixODBC-devel)
- PyODBC (pip install pyodbc)
- Dremio ODBC Driver (https://download.dremio.com/odbc-driver/dremio-odbc-LATEST.x86_64.rpm)
Debian:
-
Unix ODBC (sudo yum install -y unixodbc unixodbc-dev)
-
PyODBC (pip install pyodbc)
-
Dremio ODBC Driver (https://download.dremio.com/odbc-driver/dremio-odbc-LATEST.x86_64.rpm)
- Use alien to convert it into deb and then install it.
Usage
ODBC
Connection String example:
dremio://user:password@host:port/dremio;SSL=0
You can specify other ODBC parameters seperated by semi colon.
Arrow Flight
- This is experiemental. Not recommended for production usage.
Connection String example:
dremio+flight://user:password@host:port/dremio
Refer https://github.com/dremio-hub/dremio-flight-connector for configuring flight endpoint in Dremio.
Testing
Set the environment variable DREMIO_CONNECTION_STRING:
Windows:
setx DREMIO_CONNECTION_URL "dremio://dremio:dremio123@localhost:31010/dremio"
Linux:
export DREMIO_CONNECTION_URL="dremio://dremio:dremio123@localhost:31010/dremio"
And then run:
py.test test
Superset Integration
This SQLAlchemy can be used for connecting Dremio with Superset. Please check superset website for more instructions on the setup.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.