Connect Estuary with ClickHouse

Estuary is a right-time data platform that flexibly combines real-time and batch data in simple-to-setup ETL pipelines. With enterprise-grade security and deployment options, Estuary unlocks durable data flows from SaaS, database, and streaming sources to a variety of destinations, including ClickHouse. Estuary provides two main ways to integrate with ClickHouse:

• Directly connect to your ClickHouse database.
• Connect via Kafka ClickPipes.

In both cases, Estuary handles data capture and movement. You don’t need to maintain your own Kafka ecosystem or other infrastructure.

​

When to choose each integration

Estuary’s direct ClickHouse materialization is recommended for most use cases. It is specifically designed to integrate with ClickHouse’s native protocol and supports self-hosted deployments as well as ClickHouse Cloud instances. Opt for the ClickPipe integration instead if you specifically want to manage your pipelines via ClickPipes. This allows you to handle incoming data like Kafka messages.

​

Additional resources

For more on setting up an integration with Estuary, see Estuary’s documentation:

• Explore Estuary’s capabilities.
• See reference documentation for Estuary’s direct ClickHouse materialization connector.
• See reference documentation for Estuary’s Kafka ClickPipe integration.
• To see a list of sources that you can stream into ClickHouse with Estuary, check out Estuary’s capture connectors.