---
title: ClickHouse Open Source
description: Query logs from your self-managed, open-source ClickHouse clusters.
breadcrumbs: Docs > Integrations > ClickHouse Open Source
---

> For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt).

# ClickHouse Open Source
Integration version1.0.0
{% callout %}
# Important note for users on the following Datadog sites: us2.ddog-gov.com

{% alert level="info" %}
To find out if this integration is available in your organization, see your [Datadog Integrations](https://app.datadoghq.com/integrations) page or ask your organization administrator.

To initiate an exception request to enable this integration for your organization, email [support@ddog-gov.com](mailto:support@ddog-gov.com).
{% /alert %}

{% /callout %}

## Overview{% #overview %}

The Datadog ClickHouse Open Source integration connects your self-managed, open-source [ClickHouse](https://clickhouse.com/) 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{% #setup %}

### Prerequisites{% #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{% #connect-your-clickhouse-account-to-datadog %}

1. 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.         |

1. 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.

1. Click **Save**.

### Validation{% #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{% #data-collected %}

### Logs{% #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{% #metrics %}

The ClickHouse Open Source integration does not include any metrics.

### Service Checks{% #service-checks %}

The ClickHouse Open Source integration does not include any service checks.

### Events{% #events %}

The ClickHouse Open Source integration does not include any events.

## Support{% #support %}

Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).