ClickHouse - Data

ClickHouse  is a high-performance, column-oriented SQL database management system (DBMS) for online analytical processing (OLAP). 

You can import data from ClickHouse into Blueshift using the RudderStack Reverse ETL platform. 

Integration via the RudderStack platform

RudderStack is an open-source Customer Data Platform (CDP), providing data pipelines that allow you to easily collect data from every application, website, and SaaS platform to activate in your warehouse and business tools. Using RudderStack, you can easily copy data from ClickHouse into Blueshift.

Using RudderStack you can import the following data into Blueshift:

• Customer data
• Event data (Standard events and Custom events)

To integrate with Blueshift via RudderStack, complete the following steps:

1. Set up ClickHouse as a Reverse ETL source in RudderStack.
2. Set up Blueshift as a destination in RudderStack.
3. Create a Connection in Rudderstack with ClickHouse as the source and Blueshift as the destination.