How Picnic uses ClickHouse for real-time analytics across 20+ fulfillment centers and 1 million unique stores

Picnic leverages ClickHouse Cloud to drive real-time analytics across its extensive network of automated fulfillment centers, enhancing its ability to manage millions of unique shopping journeys efficiently. Transitioning from TimescaleDB, Picnic reduced operational complexity and expanded self-service capabilities through dbt models and SQL dashboards. The real-time insights platform, powered by ClickHouse, processes operational events to provide metrics and dashboards tailored for warehouse teams, enabling them to track supply chain operations without developer intervention. This system allows Picnic to maintain its promise of timely deliveries by offering real-time data on order status, stock levels, and workforce distribution across its diverse fulfillment environments. The platform's architecture includes Java services, RabbitMQ, Apache Kafka, and ClickHouse, with Grafana used for visualization. The integration of ClickHouse has facilitated rapid growth in dbt model deployment and improved data operations scalability. Picnic's future plans involve utilizing ClickHouse for stream processing and exploring AI applications to enhance model generation and validation, ensuring continued innovation in its analytics capabilities.