5 min read
|
Saved February 14, 2026
|
Copied!
Do you care about this?
Hannah, a Customer Engineer at MotherDuck, developed a personalized performance summary for her team using SQL. The project compiled metrics like query counts and database creations, assigning playful "duck personas" based on performance. The article outlines the technical steps taken to filter data and generate the final report.
If you do, here's more
Hannah, a Customer Engineer at MotherDuck, created an internal version of Spotify Wrapped for her team, highlighting key metrics derived from their SQL data. Over the past year, she ran 1.15 million queries, shared 54 databases, and tracked various performance indicators for her colleagues. Notably, Elena had the longest streak of 182 consecutive days of query activity, while Alex created 2,176 databases, averaging six per day. Gaby processed an impressive 217 terabytes of data, indicating significant involvement in debugging.
The process involved filtering out non-employee data, aggregating user metrics, and calculating percentiles to determine rankings. The SQL queries used included complex operations, such as joining several common table expressions (CTEs) to compile the final results. Hannah emphasized the importance of excluding service accounts and test aliases to ensure accurate analysis. The final output included various archetypes assigned to users based on their performance, such as "Elite Duck" for the top 1% and "Streak Master" for those with long consecutive activity. This project not only showcased individual achievements but also fostered team engagement and recognition.
Questions about this article
No questions yet.