Acceldata
 ADOC
Search documentation… ⌘K

Last updated: Sep 29, 2026 09:27 UTC

ClickHouse

ClickHouse is a high-performance, column-oriented database designed for large-scale analytics. It stores data in columns instead of rows, making it extremely fast for aggregations and queries—even across billions of records. This makes it ideal for real-time reporting, dashboards, and observability use cases.

Prerequisites

Ensure the following requirements are met before you connect ClickHouse as a data source:

  • ClickHouse access details: JDBC connection information (host, port, database, username, password/secret).
  • Acceldata setup: An active ADOC account with permissions to add data sources.
  • Data Plane: An existing data plane in ADOC (or the ability to create one for ClickHouse ingestion). See the Data Plane Installation documentation for more information.

Add ClickHouse as a Data Source

Step 1: Start Setup

  • Navigate to the left main navigation menu, click Control Center -> Integrations.
  • From the Integrations page, click Add Data Source and select ClickHouse from the data sources list.
  • On the Data Source Details page:
    • Enter a name and optional Description for the data source.
  • Ensure the Data Reliability toggle is enabled and select the required data plane.
  • Click Next.

Step 2: Enter Connection Details

To connect to your ClickHouse database:

  • Enter your JDBC URL in the format: jdbc:clickhouse://<host>:<port>/<database>
  • Enter your username and password (or select a secret manager)
  • Click Test Connection. A "Connected" message will appear if successful. Otherwise, re-check your credentials, JDBC URL, and format.

Step 3: Set Up Observability

Now define what ADOC should monitor in ClickHouse.

  • Select the databases in ClickHouse you want to monitor.
  • Use Crawler Execution Schedule to set when background jobs scan files and collect metadata for observability:
    • Select how often the crawler runs (e.g., daily)
    • Set execution time and time zone
    • Add multiple execution schedules if needed
  • Configure Notifications:
    • Notify on Crawler Failure: Select one or more channels for failure alerts.
    • Notify on Success: Receive success notifications (toggle on/off)
  • Click Submit to save your configuration and start monitoring your ClickHouse data source.

Your ClickHouse data source will now appear on the Data Sources page.

What’s Next

  • Create and Apply Policies: Define data observability policies, such as data quality, reconciliation, data drift, schema drift, and anomaly detection. These policies are required for ADOC to generate insights from your ClickHouse data.
  • Monitor Dashboards: After applying policies, explore ADOC dashboards to track metrics, detect anomalies, and measure health of your ClickHouse data.
  • Set Up Alerts: Configure up alerts for critical events (like schema changes, anomalies, or reconciliation failures) to act quickly.