To find out if this integration is available in your organization, see your Datadog Integrations page or ask your organization administrator.
To initiate an exception request to enable this integration for your organization, email support@ddog-gov.com.
Overview
The Datadog ClickHouse Open Source integration connects your self-managed, open-source ClickHouse cluster to Datadog so you can query your ClickHouse-resident logs from Datadog without ingesting them. You provide the connection endpoint and credentials for your cluster; Datadog stores them securely and queries your data in place through its federated query layer, so your logs stay in your own ClickHouse cluster.
Setup
Prerequisites
- A ClickHouse HTTP(S) endpoint that is reachable from Datadog (for example,
https://<host>:8443). - A ClickHouse user with permission to read the data you want to query.
Connect your ClickHouse account to Datadog
On the ClickHouse Open Source tile, enter the following:
| Parameter | Description |
|---|
| Account name | A name to help you identify this ClickHouse account later. |
| ClickHouse HTTP URL | The HTTP(S) URL of your ClickHouse server. Example: https://<host>:8443 |
| Username | The ClickHouse user Datadog authenticates as. |
| Password | The password for that ClickHouse user. |
| Database | (Optional) The database to scope queries to. |
| Tags | (Optional) Custom tags applied to logs queried from this cluster. |
Enable Allow Federated Logs to query this cluster. This toggle is off by default, and it is what grants Federated Logs query access to your cluster. Until it is enabled, Datadog stores the account but does not run any queries against your ClickHouse cluster.
Click Save.
Validation
After saving, confirm the account shows as connected on the tile. Because query access is opt-in, also make sure Allow Federated Logs to query this cluster is enabled; otherwise the account can appear connected while federated queries stay disabled. With the account connected and the toggle on, you can query your ClickHouse-resident logs from Datadog; Datadog reads the data from your cluster in place at query time.
Data Collected
Logs
Datadog queries logs from your ClickHouse cluster in place through its federated query layer. Logs are not ingested into or stored in Datadog.
Metrics
The ClickHouse Open Source integration does not include any metrics.
Service Checks
The ClickHouse Open Source integration does not include any service checks.
Events
The ClickHouse Open Source integration does not include any events.
Support
Need help? Contact Datadog support.