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:
From the left panel, go to Source > New Source > Reverse ETL. Then, select ClickHouse:
Assign a name to your source.
Configuring the connection credentials
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.
cookies, the cookies that are categorized as necessary are stored on your browser as they are as
for the working of basic functionalities of the website. We also use third-party cookies that
analyze and understand how you use this website. These cookies will be stored in your browser
consent. You also have the option to opt-out of these cookies. But opting out of some of these
have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This
category only includes cookies that ensures basic functionalities and security
features of the website. These cookies do not store any personal information.
learn more about cookies and why we use them, visit our cookie
policy. We'll assume you're ok with this, but you can opt-out if you wish Cookie Settings.