ClickHouse Reverse ETL Source

You can now sync SQL audiences from ClickHouse with the ClickHouse Reverse ETL Source. Connect ClickHouse in Rudder Lookout, build an audience, and activate it to a destination. Lookout automatically creates the source in your linked RudderStack workspace when you activate the audience.

The ClickHouse Reverse ETL Source is in Private Beta.

Reach out to Customer Success to enable it for your workspace.

Key features

• SQL audiences in mirror mode: Build the audience in Lookout and activate it to a destination.
• Read-only access to your tables: RudderStack reads the rows your audience selects and writes only to a separate _rudderstack database, where it keeps snapshots and sync state.
• Diffs computed in ClickHouse: Each sync snapshots the current audience on your server and compares it with the previous snapshot. A normal sync sends removed members, then changed members, then new members.
• ClickHouse Cloud or a single node: Connect ClickHouse Cloud, including a service with several replicas, or a self-hosted server on one node. The server must run version 26.3 or later and accept HTTPS on a public address.

Get started

A Lookout admin adds the warehouse connection.

1. Reach out to Customer Success to enable the ClickHouse source for your workspace. Then, follow How to Connect Your RudderStack Workspace to Lookout.
2. In Lookout, go to Settings > Warehouses, click Add account, and select ClickHouse.
3. Enter the connection settings. Check the Setup SQL under the form, and ask a ClickHouse administrator to run it if they haven’t already.
4. Click Validate and create.
5. Build an audience on the ClickHouse connection and activate it to a destination.

See the ClickHouse Reverse ETL Source for the grant script, connection settings, and what you can sync.

Resources

• Grant permissions: The user, the _rudderstack database, and the grants each sync needs
• How to Build an Audience with the Agent: Build the audience on your ClickHouse connection
• How to Activate an Audience to a Destination: Send the audience to a destination and start the sync