Integrations

SQLAlchemy

Install SQLAlchemy

pip install sqlalchemy-exasol

Connect to Exasol database using SQLAlchemy

from sqlalchemy import create_engine
url = "exa+websocket://<user>:<password>@<host>:<port>/<schema>?CONNECTIONLCALL=en_US.UTF-8"
e = create_engine(url)
r = e.execute("select 42 from dual").fetchall()

Please also refer to sqlalchemy exasol documentation.

JupySQL

How to work with JupySQL in JupyterLab is described in Environments.

Pandas

Importing Data into Pandas

You can fetch data from Exasol into a Pandas DataFrame using pyexasol.

import pandas as pd

# Execute a query and fetch data into a Pandas DataFrame, Conn is an existing pyexasol connection.
df = conn.export_to_pandas('SELECT * FROM <your_table_name>')

# Display the DataFrame
print(df)

Exporting Data from Pandas to Exasol

You can also export data from a Pandas DataFrame to an Exasol table.

# Assume you have a Pandas DataFrame `df` you wish to export
conn.import_from_pandas(df, '<your_target_table_name>')

Ibis

Please refer to the IBIS documentation.

You can also watch this video for a step by step walk through of using Ibis with Exasol via AI Lab.