Powering self-driving vehicle analytics at Avride with ClickHouse Cloud

Avride leverages ClickHouse Cloud as the central data infrastructure for its autonomous vehicle and delivery robot fleet, significantly improving data processing efficiency after transitioning from Apache Iceberg. This migration resulted in a dramatic reduction of index lookup latency from 20 seconds to under 100 milliseconds and ingestion latency from hours or days to mere seconds. Despite the team's extensive experience with ClickHouse, they opted for ClickHouse Cloud due to its operational simplicity and the benefits of separating storage and compute, which allows for scalable and cost-effective data management. Their data pipeline begins with vehicles generating vast amounts of sensor data, which is processed to produce both offline and online metrics for various use cases, from real-time fleet monitoring to C++ performance profiling. The choice to use ClickHouse Cloud is driven by its ability to handle parallel writes efficiently and eliminate data duplication, which were limitations with Iceberg. ClickHouse Cloud's features, including its SQL console, enhance usability across the company, supporting a wide range of applications from engineering to executive decision-making. As Avride's fleet and data demands grow, ClickHouse Cloud provides a robust and scalable solution, making it their default choice for future expansion.