Connect Clickhouse data with any data source.

Sync any source into Clickhouse on the schedule you set.

Load data into Clickhouse Read the docs

Sources: 590+
Certified support: 2.1.31

Overview

What is the Airbyte Clickhouse connector?

The Airbyte Clickhouse connector loads data from 590+ Airbyte sources into Clickhouse, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into Clickhouse from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the Clickhouse connector on Cloud, OSS, Hybrid.

Setup

Live in three steps

Confirm your Clickhouse destination credentials and permissions.
Configure the destination in Airbyte with the required connection settings.
Choose a source, map streams, and schedule syncs into Clickhouse.

Configuration fields

Clickhouse configuration fields
Field	Type	Description
database*	string	Name of the database.
host*	string	Hostname of the database.
password*	string	Password associated with the username.
port*	string	HTTP port of the database. Default(s) HTTP: 8123 — HTTPS: 8443
protocol*	string	Protocol for the database connection string.
username*	string	Username to use to access the database.
cluster_name	string	Name of your ClickHouse cluster. When provided, table definitions are automatically propagated to all cluster nodes. Required for clusters using the Atomic database engine. Leave empty for single-node setups, ClickHouse Cloud, or databases using the Replicated database engine.
enable_json	boolean	Use the JSON type for Object fields. If disabled, the JSON will be converted to a string.

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 load into Clickhouse with Airbyte?

Airbyte moves data from any supported source into Clickhouse on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the Clickhouse connector support incremental sync?

Yes. The Clickhouse destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

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