---
title: "Integrating ClickHouse with CloudQuery"
description: "High performance open-source ELT framework for building infrastructure and security lakes"
category: "DATA_INGESTION"
support: "PARTNER"
docs: "https://www.cloudquery.io/hub/plugins/destination/cloudquery/clickhouse/latest/docs"
---

# CloudQuery



<p>Download <a href="https://docs.cloudquery.io/docs/quickstart" target="_blank">CloudQuery CLI</a> or get started with <a href="https://cloud.cloudquery.io" target="_blank">CloudQuery Cloud</a>.</p>



<p>Select a source from <a href="https://hub.cloudquery.io/plugins/source" target="_blank">CloudQuery Hub</a>.</p>



Configure ClickHouse destination plugin:

```yaml
kind: destination
spec:
  name: "clickhouse"
  path: "cloudquery/clickhouse"
  registry: "cloudquery"
  version: "v4.0.2"
  write_mode: "append"
  spec:
    connection_string: "clickhouse://${CH_USER}:${CH_PASSWORD}@localhost:9000/${CH_DATABASE}"
    # Optional parameters
    # cluster: ""
    # ca_cert: ""
    # engine:
    #   name: MergeTree
    #   parameters: []
    #
    # batch_size: 10000
    # batch_size_bytes: 5242880 # 5 MiB
    # batch_timeout: 20s
```



Run the sync:

```shell
cloudquery sync source.yaml clickhouse.yaml
```