How We Built Tinybird Wrapped: A Year in Data

Wrapped features have become a ubiquitous year-end trend, popularized by companies like Spotify, GitHub, and Strava, and have now been implemented by Tinybird to provide a yearly recap for their customers. Built on Tinybird's managed ClickHouse infrastructure, the Tinybird Wrapped feature efficiently aggregates and processes vast amounts of data across multiple regions using a lambda architecture, which combines real-time and historical data, ensuring subsecond query responses and data deduplication. This architecture leverages S3 and Parquet as a data interoperability layer, allowing for seamless data collection and aggregation without significant operational overhead. The implementation includes robust privacy measures, such as JWT-based security and the use of public-safe identifiers, to protect customer data. The frontend application, crafted with Next.js and enhanced by GSAP animations, presents the data in an engaging and visually dynamic manner. The project showcases how Tinybird's existing infrastructure can be utilized to quickly develop a complex analytical feature by writing a few queries and building a straightforward, visually appealing interface.