Prerequisites
- A reachable ClickHouse HTTPS endpoint. ClickHouse Cloud exposes this on port
8443(e.g.,https://<host>.clickhouse.cloud:8443). Self-hosted ClickHouse typically listens on8443(HTTPS) or8123(HTTP). See ClickHouse network ports. - A read-only user with
SELECTaccess on the databases Resolve AI should query. See Permissions for queries for the recommendedreadonlysettings profile.
Connect ClickHouse
- Open ClickHouse Integration in Resolve AI.
- Click Add Connection.
- Enter a Name (e.g.,
ClickHouse-Main). - Leave Environments blank to ingest data from all environments, or list specific ones that match your Satellite config.
- Enter the URL of your ClickHouse HTTPS endpoint, including the port (e.g.,
https://<host>.clickhouse.cloud:8443). - Enter the Username and Password of the read-only user.
- Click Save.
Verify the integration
Once saved, the connection status is shown on the integration page. A green status indicates Resolve AI can reach ClickHouse and run test queries. If the check fails:- Network: confirm the ClickHouse URL is reachable from Resolve AI’s cloud, or from your Resolve Satellite if you deploy on-prem.
- Credentials: test the username and password with
clickhouse-clientorcurlagainst the HTTPS endpoint. - Permissions: confirm the ClickHouse user has
SELECTon the databases Resolve AI should query.

