Exasol

https://www.exasol.com/

Exasol is a high-performance, in-memory, MPP analytical database.

Installation

Required packages: sqlalchemy-exasol

Drivers

pyodbcRecommended

turbodbc

websocket

PyPI Package: sqlalchemy-exasol

exa+pyodbc://{username}:{password}@{dsn}

Requires ODBC driver and DSN configuration.

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 28/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Troubleshooting

Common error messages you may encounter when connecting to or querying Exasol, along with their causes and solutions.

Permissions1 error

Query3 errors

Notes

SQL Lab recognizes Exasol syntax errors, missing-table and missing-column errors, and insufficient-privilege errors while retaining the server's diagnostic text. Echoed SQL is excluded from error classification. An ambiguous `object ... not found` message remains a generic database error; it does not distinguish a missing table from a missing column. For WebSocket connections, use PyExasol 2.4.1 or later to preserve server messages in DB-API exceptions. Earlier versions can return an empty error message.

Help improve this documentation by editing the engine spec:

Edit exasol.py