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.
1 maintainer
Metadata
1 maintainer
Release files for preset-sqlalchemy-dremio 1.2.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| preset_sqlalchemy_dremio-1.2.1.tar.gz | 15.2 kB | Without provenance | Details for preset_sqlalchemy_dremio-1.2.1.tar.gz |
Release files / preset_sqlalchemy_dremio-1.2.1.tar.gz
| Download URL | preset_sqlalchemy_dremio-1.2.1.tar.gz |
|---|---|
| Size | 15.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
4465eca9554bcfdecbe35261a2fcbbd54d29787e42ebb15c5c56de3cd47f8a2b
|
|
BLAKE2b-256 checksum How to use checksums |
d84f5bd0704e39fc070b023a72590f088a6cb43294e5d82ee68ecf8620d93bef
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.3
|
Security for preset-sqlalchemy-dremio 1.2.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
