How we rebuilt Time Series: the SQL problems we hit, the ClickHouse patterns we used, and how we use it to debug our own alerts.

Tinybird is a real-time data analytics platform for building fast and scalable data pipelines, offering tools for data ingestion, processing, and visualization. From this blog users can learn about stream processing, data warehousing, and analytics techniques to unlock insights from their data and make data-driven decisions.

Tinybird

Tinybird rebuilt their Time Series feature from scratch, translating user selections into SQL queries that handle ClickHouse-specific challenges. The implementation addresses time gap filling with arrayJoin and full outer joins, timestamp alignment using toStartOfInterval, and adaptive granularity based on time ranges. The feature includes split-screen schema inspection, query cancellation, workspace sharing, and integration with Observability for investigating production incidents.

How We Built Time Series: Configuration-Driven Visualization in Tinybird Forward