Flock Safety, a company that provides automated license plate readers, video cameras, and gunfire detection systems to help deter crime and aid criminal investigations, has transitioned its data architecture from Amazon Redshift to ClickHouse Cloud. The new architecture allows for real-time analytics and data updates, eliminating the need for daily refreshes and reducing downtime. With ClickHouse's AggregatingMergeTree tables and materialized views, Flock Safety can now process large volumes of data quickly and efficiently, providing customers with 24/7 access to the latest data. The transition has also enabled long-term data retention, giving customers richer insights and deeper trend analysis. By switching to ClickHouse Cloud, Flock Safety aims to provide its customers with real-time insights that help them make smarter, data-driven decisions, ultimately contributing to safer communities.