ClickHouse

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 https //clickhouse com/docs/guides/sre/network ports a read only user with select access on the databases resolve ai should query see https //clickhouse com/docs/operations/settings/permissions for queries for the recommended readonly settings profile connect clickhouse open https //app0 resolve ai/integrations/clickhouse/connect 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 docid 2o37z2kheilqdmbqcltmq 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