ClickHouse
Connect a ClickHouse database to Lakehousecat as a source for semantic extraction and analytics.
note
ClickHouse is also used internally by Lakehousecat as the analytics warehouse. This page covers connecting an external ClickHouse instance as a data source.
Connection Fields
| Field | Required | Description |
|---|---|---|
| Connection URI | Yes | Full connection string. Example: clickhouse://user:password@host:8123/database |
| Use SSH | No | Enable to connect through an SSH bastion host. |
Prerequisites
- Admin or Builder role in Lakehousecat
- A ClickHouse user with read access (
SELECT) to the databases and tables you want to expose - Network connectivity from the Lakehousecat backend to the ClickHouse HTTP interface (default port 8123)
Notes
- Use a dedicated read-only user to avoid exposing system tables.
- Lakehousecat uses the ClickHouse HTTP interface for connectivity.
- Incremental Load is supported; use a timestamp column (e.g.,
updated_at) as the merge key.
Next Steps
After creating the datasource, go to the Operations tab to trigger semantic extraction.