Website | Docs | Kinetica Dialect for SQLAlchemy Docs | Community Slack

Kinetica Dialect for SQLAlchemy

• Overview
• Support
• Contact Us

Overview

This project contains the source code of the Kinetica Dialect for SQLAlchemy, as well as a number of examples of how to perform both standard & non-standard SQL functions.

Relevant Kinetica documentation available:

• Full Documentation
• Kinetica Dialect for SQLAlchemy
• Python API

Installation

To install the Kinetica Dialect for SQLAlchemy, use pip:

pip3 install sqlalchemy-kinetica

For changes to the client-side API, please refer to CHANGELOG.md.

Usage

To run the example suite, switch to the examples directory and run the basic examples. These show how to use SQLAlchemy with SQL literal text.

cd examples
python3 basic_examples.py <kinetica_url> <username> <password> <schema> <bypass_ssl_cert_check>

Alternatively, run the Kinetica Dialect for SQLAlchemy examples. These show how to use the Kinetica dialect to take advantage of advanced SQL and Kinetica-specific features.

cd examples
python3 sqlalchemy_api_examples.py <kinetica_url> <username> <password> <schema> <bypass_ssl_cert_check> <recreate_schema>

Note: Some examples use demo tables packaged with Kinetica. Those can be loaded from within the Demo section of GAdmin.

Support

For bugs, please submit an issue on Github.

For support, you can post on stackoverflow under the kinetica tag or Slack.

Contact Us

• Ask a question on Slack: Slack
• Follow on GitHub: Follow @kineticadb
• Email us: support@kinetica.com
• Visit: https://www.kinetica.com/contact/