Skip to main content
The ClickHouse integration can be configured via Resolve’s UI. ResolveAI 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 ResolveAI should query. See Permissions for queries for the recommended readonly settings profile.

​
Connect ClickHouse

  1. Open ClickHouse Integration in ResolveAI.
  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 ResolveAI can reach ClickHouse and run test queries. If the check fails:
  • Network: confirm the ClickHouse URL is reachable from ResolveAI’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 ResolveAI should query.