Fork of sqlalchemy-dremio 1.2.1 for parallel deployment with newer versions
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 yum 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 apt 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.
Source Distribution
File details
Details for the file preset_sqlalchemy_dremio-1.2.1.tar.gz
.
File metadata
- Download URL: preset_sqlalchemy_dremio-1.2.1.tar.gz
- Upload date:
- Size: 15.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.3
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4465eca9554bcfdecbe35261a2fcbbd54d29787e42ebb15c5c56de3cd47f8a2b |
|
MD5 | 02460aeb247d86a40bdbbe683a698643 |
|
BLAKE2b-256 | d84f5bd0704e39fc070b023a72590f088a6cb43294e5d82ee68ecf8620d93bef |