Skip to main content

Fork of sqlalchemy-dremio 1.2.1 for parallel deployment with newer versions

Project description

SQLAlchemy Dremio

PyPI Build

A SQLAlchemy dialect for Dremio via ODBC and Flight interfaces.

Installation

pip install sqlalchemy_dremio

Pre-Requisites

Mac OS X:

CentOS/RHEL:

Debian:

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

preset_sqlalchemy_dremio-1.2.1.tar.gz (15.2 kB view details)

Uploaded Source

File details

Details for the file preset_sqlalchemy_dremio-1.2.1.tar.gz.

File metadata

File hashes

Hashes for preset_sqlalchemy_dremio-1.2.1.tar.gz
Algorithm Hash digest
SHA256 4465eca9554bcfdecbe35261a2fcbbd54d29787e42ebb15c5c56de3cd47f8a2b
MD5 02460aeb247d86a40bdbbe683a698643
BLAKE2b-256 d84f5bd0704e39fc070b023a72590f088a6cb43294e5d82ee68ecf8620d93bef

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page