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:
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.
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.
For bugs, please submit an issue on Github.
For support, you can post on
stackoverflow under the
kinetica tag or
Slack.
- Ask a question on Slack: Slack
- Follow on GitHub: Follow @kineticadb
- Email us: [email protected]
- Visit: https://www.kinetica.com/contact/