ClickHouse reverse ETL source

ClickHouse is an open-source, column-oriented database management system mainly used for online analytical processing (OLAP). It lets you generate analytical reports that are updated in real-time using SQL queries. ClickHouse is highly scalable, fast, and built for high performance.

RudderStack supports ClickHouse as a source from which you can ingest data and route it to your desired downstream destinations.

Setting up the ClickHouse source in RudderStack

To set up ClickHouse as a source in RudderStack, follow these steps:

Naming the source

1. Log into your RudderStack dashboard.
2. From the left panel, go to Source > New Source > Reverse ETL. Then, select ClickHouse:

3. Assign a name to your source.

Configuring the connection credentials

1. Enter the relevant settings in the Connection Credentials section as listed below:

• Host - Enter the host name of your ClickHouse service.
• Port - Enter the port number of your ClickHouse service.
• Database - Enter the database name in your ClickHouse instance from where the data is to be imported.
• User - Enter the name of the user having the required read/write access to the above database.
• Password - Enter the password for the above user.
• Secure - Enabling this setting establishes a secure connection and displays additional settings as shown below:

If you have already configured a destination in RudderStack, choose the Use Existing Destination option which will take you to the Schema tab in the source settings. To add a new destination from scratch, select the Create New Destination option which will take you to the destination configuration page.

Specifying the data to import

While connecting a destination to your Reverse ETL source, you can use the default JSON mapping or the Visual Data Mapping feature.

For more information on the data import settings, refer to the Importing Data using Tables guide.

Questions? Contact us by email or on Slack