Case Study: Flock Safety achieves real-time vehicle traffic analytics with ClickHouse Cloud

Why Flock Safety turned to ClickHouse for real-time vehicle traffic analytics

Flock Safety, a public safety technology company, needed a better way to power its traffic analytics platform with real-time insights. Its existing stack, built on Amazon Redshift, DBT, Prefect, and QuickSight SPICE, suffered from daily refreshes, long processing delays, and dataset size limits that prevented customers from seeing up-to-date vehicle traffic data.

Flock Safety moved to ClickHouse Cloud, using ClickPipes, materialized views, and AggregatingMergeTree/ReplacingMergeTree table designs to ingest, transform, and query data directly in ClickHouse. With ClickHouse, the company eliminated SPICE downtime, cut query times to under five seconds, enabled 24/7 access to current data, and scaled to over 1 billion ML predictions per day with zero downtime.

Flock Safety

Leon Kozlowski

Data Engineering Manager