user_guide.rst

:octicon:`person` User Guide

SQLAlchemy-Exasol is a dialect extension for SQLAlchemy, implementing support for Exasol databases.

Getting Started

1. Install the SQLAlchemy-Exasol extension

   $ pip install sqlalchemy-exasol

   Note

   SQLAlchemy will be installed due to the fact that it is an required dependency for SQLAlchemy-Exasol.

2. Execute queries

   from sqlalchemy import create_engine
   url = "exa+pyodbc://A_USER:[email protected]:1234/my_schema?CONNECTIONLCALL=en_US.UTF-8&driver=EXAODBC"
   e = create_engine(url)
   r = e.execute("select 42 from dual").fetchall()

For more details on SQLAlchemy consult it's documenation.

Readme