Skip to main content
Python Software Foundation 20th Year Anniversary Fundraiser  Donate today!

A SQLAlchemy dialect for Dremio via the ODBC and Flight interface.

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.

Files for sqlalchemy-dremio, version 1.1.5
Filename, size File type Python version Upload date Hashes
Filename, size sqlalchemy_dremio-1.1.5.tar.gz (14.6 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page