SQLAlchemy Dremio
A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.
Installation
From pip:
pip install sqlalchemy_dremio
Or from conda:
conda install sqlalchemy-dremio
To install from source:
python setup.py install
Usage
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 verification.
WLM:
routing_queue - (Optional) The queue in which queries should run routing_tag - (Optional) Routing tag to use. routing_engine - (Optional) The engine in which the queries should run
Testing
You can run the integration tests with the Dremio community edition Docker image.
docker run -d -p 9047:9047 -p 31010:31010 -p 32010:32010 --name dremio dremio/dremio-oss:latest
export DREMIO_CONNECTION_URL="dremio+flight://dremio:dremio123@localhost:32010/dremio?UseEncryption=false"
pytest
The workflow in .github/workflows/dremio.yml demonstrates how to run these tests automatically on GitHub Actions.
The CI badge at the top of this file shows the current test status.
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.4
- Addressing issue #34 and #37: Add driver name to dialects
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
1 maintainer
Metadata
1 maintainer
Release files for sqlalchemy-dremio 3.0.5
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 | |
|---|---|---|---|---|
| sqlalchemy_dremio-3.0.5.tar.gz | 17.7 kB | Without provenance | Details |
Release files / sqlalchemy_dremio-3.0.5.tar.gz
| Download URL | sqlalchemy_dremio-3.0.5.tar.gz |
|---|---|
| Size | 17.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
d45bb7a2d226a113981ddbf312e69a9c278534d73162d6a68731b5ce3e50839b
|
|
BLAKE2b-256 checksum How to use checksums |
888d16dbb76c65ff0e5e3a350af1ded4338a84c7006d091946fd01465344bb7f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.0 CPython/3.12.3
|
Security for sqlalchemy-dremio 3.0.5
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.
