Skip to main content
Version: Next

Exasol

Connect an Exasol in-memory analytics database to Lakehousecat using a connection URI.

Connection Fields​

FieldRequiredDescription
Connection URIYesFull connection string. Example: exasol://user:password@host:8563/database
Use SSHNoEnable if the database is behind an SSH bastion host. See SSH Tunneling.

Prerequisites​

  • Admin or Builder role in Lakehousecat
  • An Exasol user with SELECT access 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.