Learn how we built Tinybird Wrapped, a yearly recap feature that aggregates and visualizes customer usage metrics across multiple regions, time periods, and data sources using... Tinybird!

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

A detailed technical breakdown of building a year-in-review analytics feature using a multi-region data architecture. The implementation uses S3 and Parquet for data interoperability, a lambda architecture with ReplacingMergeTree and materialized views for deduplication and aggregation at scale, and JWT-based security with public-safe identifiers. The system processes billions of rows across multiple regions with subsecond query responses, combining ClickHouse for the backend with a Next.js frontend featuring GSAP animations.

How We Built Tinybird Wrapped: A Year in Data

The Lambda Architecture: Deduplication at scale