Two years of event history sits in one hot warehouse table

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

Domain

Pipeline Design

Difficulty

medium

Problem

Two years of event history sits in one hot warehouse table. 95% of queries touch the last 30 days, but the team pays hot-storage prices for all of it. Design tiered storage that keeps recent data fast and old data cheap, still queryable.

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.