ClickHouse and Row64

ClickHouse is an open-source columnar database for fast analytical SQL on very large data, with streaming ingest from Kafka and a managed ClickHouse Cloud service. For the data teams behind it, Row64 adds the screen their operators need: current state on a live map, drilled to one asset, with the next step sent from the same place.

Reviewed November 2026

Keep ClickHouse for

  • Analytical SQL on very large data.

    Fast queries over billions of rows of event, log and product data.

  • Streaming ingest.

    Events arrive from Kafka and other sources and are ready to query almost at once.

  • Open source or managed.

    Run it yourself as open source, or use ClickHouse Cloud.

Add Row64 for

  • Current state, without a SQL query.

    Row64 holds the latest state of every asset in memory and updates the screen as events arrive, so nobody writes a query to see it.

  • Rows become points on a live map.

    Millions of points rendered on the GPU at full detail, cross-filtered with tables and drilled to one asset while the data updates.

  • A response, not just a result set.

    Rules send alerts, tickets and REST calls the moment a pattern appears, automatically or with an operator deciding, and the result comes back live.

In practice

A few noisy sensors, or an attack on one region?

With Row64, a security team storing its network events in ClickHouse can see every sensor across its sites as events arrive, without writing a query. Late on a Sunday, incident counts at 40 stores in Southern California jump from a handful to hundreds in ten minutes.

Row64 flags the cluster as it forms, opens a ticket and sends a REST call that moves those stores' guest networks to a restricted profile. The on-call analyst sees most of the traffic is denial of service, checks that payments are untouched, and escalates.

ClickHouse keeps every event for Monday's investigation.

Row64 cyber sensor example with security incidents flagged on a US map, a live incident feed, and high-priority incidents by ZIP code.

How they work together

Keep your database. Add the live view on top.

01

ClickHouse stores it.

Event data, history and analytical SQL stay in ClickHouse, open source or in ClickHouse Cloud.

02

Row64 connects to it.

Row64 reads the same Kafka streams directly, and brings in database data through its Data API.

03

Row64 acts on it.

Alerts, tickets and REST calls go out automatically or from an operator's screen, and the result comes back live.