Migrating 1.3 Billion IoT Rows to ClickHouse Cloud
Dashboard timeouts during winter storms. 45-second queries when road crews need real-time data. We moved 1.3 billion IoT rows from SQL Server to ClickHouse Cloud—and cut query times from seconds to milliseconds while saving $2,200/month. Here's exactly how.
December 8, 2025 · 25 min read