Adapter: Exasol

The Exasol adapter was contributed by community member Nicola Coretti.

This documentation is Copyright Exasol, reproduced and adapted here under an MIT License. See the repository for the most up-to-date documentation.

Warning

The current state of this project is a spike—an initial evaluation of what is possible and how much effort specific tasks will require. It should only be used for evaluating Exasol usage via Harlequin.

Below, you will find information if you are interested in trying it out and getting an idea of it. While issues reported beyond the mentioned limitations are welcome for tracking purposes, addressing these issues is unlikely at any point. However, having a list of issues may be helpful to other evaluators.

🚀 Features

• Basic Catalog
• Basic Query Completion
• Basic Query Support, including DDL

Installation

You must install the harlequin-exasol package into the same environment as harlequin. The best and easiest way to do this is to use uv to install Harlequin with the additional package:

$ uv tool install harlequin --with 'harlequin-exasol'

Using Harlequin with Exasol

To connect to a Postgres database, run Harlequin with the -a exasol option and pass connection parameters as options:

$ harlequin -a exasol --schema 'foo' --host '8.9.10.1' --port 8563 ...

For connecting to a standard Exasol Docker DB, most defaults should work just fine:

$ harlequin -a exasol --disable-certificate-validation

💥 Known Issues

• Queries cannot be sent while metadata is loading. (@exaSR)
• Only empty error windows will be shown. (Multiple Reports)