Move ClickHouse data anywhere it matters.

Replicate ClickHouse data to the warehouse or AI app you use.

Sync ClickHouse free Read the docs

Source

ClickHouse

Snowflake
BigQuery
Postgres
Databricks
Claude

Destinations: 50+
Standard support: 0.4.0

Overview

What is the Airbyte ClickHouse connector?

The Airbyte ClickHouse connector extracts data from ClickHouse and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.

01
Sync to your warehouse
Land ClickHouse data in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate ClickHouse once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the ClickHouse connector on Cloud, OSS, Hybrid.

Setup

Live in eight steps

First, navigate to the Airbyte dashboard and click on the "Destinations" tab on the left-hand side of the screen.
Next, click on the "Add Destination" button in the top right corner of the screen.
Select "ClickHouse" from the list of available destinations.
Enter the necessary information for your ClickHouse database, including the host, port, username, and password.
Choose the database and table you want to connect to from the dropdown menus.
Configure any additional settings, such as the batch size or maximum number of retries.
Test the connection to ensure that everything is working properly.
Once you have successfully connected to your ClickHouse database, you can begin syncing data from your source connectors to your ClickHouse destination.

Configuration fields

ClickHouse configuration fields
Field	Type	Description
database*	string	The name of the database.
host*	string	The host endpoint of the Clickhouse cluster.
port*	integer	The port of the database.
username*	string	The username which is used to access the database.
jdbc_url_params	string	Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about JDBC URL parameters.
password	string	The password associated with this username.
ssl	boolean	Encrypt data using SSL.
tunnel_method	object	Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

ClickHouse connector questions

What data can I sync from ClickHouse with Airbyte?

The ClickHouse connector syncs the tables and events published in Airbyte docs.

Does the ClickHouse connector support incremental sync?

Yes. The ClickHouse connector supports incremental sync on selected streams, and full refresh on every stream.

Where can I run the ClickHouse connector?

Run the ClickHouse connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales