Skip to main content

Striim Platform 5.4.2 documentation

ClickHouse

ClickHouse Writer is a Striim target adapter that writes real-time streaming data and initial-load data into ClickHouse. In the context of Striim integration, ClickHouse serves as a scalable analytical target for continuously streamed data: Striim captures changes or events from a source system, optionally filters, routes, transforms, or enriches the stream, and writes the resulting events into ClickHouse, where they become available for reporting and analysis.

A typical ClickHouse Writer pipeline looks like this:

  • Striim captures data from a source system (a CDC-enabled database, a streaming platform, a NoSQL database, a SaaS application, or a file source).

  • Striim optionally filters, routes, transforms, or enriches the event stream.

  • Striim writes the resulting stream to one or more ClickHouse tables using ClickHouse Writer.

  • Analysts, applications, or BI tools query ClickHouse for reporting and analysis.