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

DevFeed: [Why Flock Safety turned to ClickHouse for real-time vehicle traffic analytics](<https://devfeed.tech/articles/why-flock-safety-turned-to-clickhouse-for-real-time-vehicle-traffic-analytics-5660.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/why-flock-safety-turned-to-clickhouse>)

Author: ClickHouse

Published: 2025-04-29T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data-architecture](<https://devfeed.tech/tags/data-architecture.md>), [data-engineering](<https://devfeed.tech/tags/data-engineering.md>), [real-time](<https://devfeed.tech/tags/real-time.md>)

## AI overview

This developer case study explains why Flock Safety moved its vehicle traffic analytics platform from an Amazon Redshift, DBT, Prefect, and QuickSight SPICE pipeline to ClickHouse Cloud. The former architecture refreshed data daily, required up to four hours to process some datasets, and made data unavailable during refreshes. ClickHouse enabled real-time analytics for camera traffic without the previous size constraints or row-level security limitations.

## Source excerpt

"With ClickHouse, our customers now have real-time analytics for their camera traffic, and there are no more constraints on size or row-level security." ~ Leon Kozlowski, Data Engineering Manager