ClickHouse
Connect ClickHouse or ClickHouse Cloud with the ClickHouse database type. QueryDesk talks to ClickHouse over its HTTP interface, not the native protocol.
Connect a database
Add the database as in Connect a database, with these values:
| Field | Value |
|---|---|
| Database type | ClickHouse |
| Port | The HTTP port: 8123, or 8443 with Encryption on. Not the native port, 9000. |
| Database name | The database to query, for example default. |
ClickHouse Cloud requires HTTPS, so turn on Enabled in the Encryption section and use port 8443.
For the credential, create a read-only user. Use readonly = 2, not 1: QueryDesk sends the credential's timeout as a setting on each query, which readonly = 1 refuses.
AI read-only
With Read only set, every AI query carries ClickHouse's readonly setting, which refuses writes and settings changes. The parser also refuses every table function, from numbers() to url(), s3() and remote(). See AI governance.