Environments

JupyterLab and JupySQL

Install SQLAlchemy and JupySQL

pip install sqlalchemy-exasol
pip install jupysql

Connect to Exasol database using SQLAlchemy

import sqlalchemy
from sqlalchemy.engine.url import URL
import getpass

db_host = 'my_exasol_host'
db_port = 8563
db_username = input('User Name:')
db_password = getpass.getpass('Password:')

websocket_url = URL.create(
    'exa+websocket',
    host=db_host,
    port=db_port,
    username=db_username,
    password=db_password
)

db_engine = sqlalchemy.create_engine(websocket_url)

Enable the Jupyter SQL Extension

%load_ext sql
%sql db_engine

Run queries against Exasol

%%sql
SELECT * FROM "FLIGHTS"."AIRLINE" LIMIT 10

Positron

You can either connect to Exasol with pyexasol as described in Getting Started or using JupySQL as described in JupyterLab and JupySQL.

pyCharm

Please follow the instructions of the official documentation of pyCharm.