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

DevFeed: [How Picnic uses ClickHouse for real-time analytics across 20+ fulfillment centers and 1 million unique stores](<https://devfeed.tech/articles/how-picnic-uses-clickhouse-for-real-time-analytics-across-20-fulfillment-centers-and-1-million-unique-stores-5496.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/picnic-real-time-analytics>)

Author: ClickHouse

Published: 2026-01-16T00: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](<https://devfeed.tech/topics/data.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [cloud-infrastructure](<https://devfeed.tech/topics/cloud-infrastructure.md>), [Grafana](<https://devfeed.tech/topics/grafana.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data](<https://devfeed.tech/tags/data.md>), [grafana](<https://devfeed.tech/tags/grafana.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

Picnic uses ClickHouse Cloud to provide real-time analytics across more than 20 automated fulfillment centers and millions of shopping journeys. The migration from TimescaleDB reduced operational complexity and supported self-service dbt models, SQL dashboards, Grafana views, and continuous event ingestion.

## Source excerpt

"ClickHouse is very easy to operate, very cost-effective, and scaling is really simple with ClickHouse Cloud. We're very happy with it." Max Sumrall, Software Engineer