Exasol
Connect an Exasol in-memory analytics database to Lakehousecat using a connection URI.
Connection Fields
| Field | Required | Description |
|---|---|---|
| Connection URI | Yes | Full connection string. Example: exasol://user:password@host:8563/database |
| Use SSH | No | Enable if the database is behind an SSH bastion host. See SSH Tunneling. |
Prerequisites
- Admin or Builder role in Lakehousecat
- An Exasol user with
SELECTaccess to the target schemas and tables - Default port: 8563
Notes
- Use a read-only database user to follow the principle of least privilege.
- Incremental Load is supported; use a timestamp column (e.g.,
updated_at) as the merge key. - Exasol schema and table names are case-insensitive and stored in uppercase by default.
Next Steps
After creating the datasource, go to the Operations tab to trigger semantic extraction.