SQLAlchemy-Exasol

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:A_PASSWORD@192.168.1.2..8: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.