Skip to main content
The ClickHouse integration can be configured via Resolve’s UI. Resolve AI can query ClickHouse for metrics, logs, and database data.

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 on 8443 (HTTPS) or 8123 (HTTP). See ClickHouse network ports.
  • A read-only user with SELECT access on the databases Resolve AI should query. See Permissions for queries for the recommended readonly settings profile.

Connect ClickHouse

  1. Open ClickHouse Integration in Resolve AI.
  2. Click Add Connection.
  3. Enter a Name (e.g., ClickHouse-Main).
  4. Leave Environments blank to ingest data from all environments, or list specific ones that match your Satellite config.
  5. Enter the URL of your ClickHouse HTTPS endpoint, including the port (e.g., https://<host>.clickhouse.cloud:8443).
  6. Enter the Username and Password of the read-only user.
  7. 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-client or curl against the HTTPS endpoint.
  • Permissions: confirm the ClickHouse user has SELECT on the databases Resolve AI should query.