Qubole SQLAlchemy Toolkit

SQLAlchemy is a Python SQL Toolkit and Object Relational Mapper (ORM) that gives developers the full flexibility and power of SQL. The primary purpose of this integration guide is to showcase a working dialect for Qubole Presto and Hive that can be used in any Python code to connect to Qubole. Some popular BI tools that use python (and will, therefore, get benefit from this integration) include Apache Superset and Redash. Furthermore, it can also be used as an ORM which is one of the general use cases of SQLAlchemy.

Qubole SQLAlchemy runs on top of the Qubole JDBC as a dialect to bridge a QDS Presto/Hive and SQLAlchemy applications.

../../../_images/sqlalchemy.png

Prerequisite

  • Java 8 or later

  • Python 3.x

Follow the instructions below: