Back to integrations

CloudQuery

partner
  • Download CloudQuery CLI or get started with CloudQuery Cloud.

  • Select a source from CloudQuery Hub.

  • Configure ClickHouse destination plugin:
    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:
    cloudquery sync source.yaml clickhouse.yaml
    

Other integrations

Get started with ClickHouse Cloud for free

We'll get you started on a 30 day trial and $300 credits to spend at your own pace.