How to use ClickHouse as a sink with RisingWave?
I'm looking for documentation or guidance on how to use ClickHouse as a sink in conjunction with RisingWave. I understand that a common approach is to use RisingWave with Kafka and then sink data to ClickHouse. Is there any existing documentation or demos available for this setup?
Tony Wang
Asked on Jun 03, 2023
Currently, there isn't any direct documentation on using ClickHouse as a sink with RisingWave. However, a demo is in progress and is expected to be available later this month. In the meantime, if you have a specific use case, the solution team can work with you to connect RisingWave to your ClickHouse cluster. For persisting data to Delta/Iceberg, there is support and documentation available, as well as a demo for sinking to Iceberg. Ad hoc queries can be run directly on materialized views in RisingWave. For Delta Lake, the support is still under consideration, especially for the open-source version, as it is closely associated with Databricks.