A New Column on a Billion Rows

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

Domain

Pipeline Design

Difficulty

hard

Seniority

L6

Problem

Our product team needs a new column added to the orders table - which has grown to a billion rows and receives 50K writes per minute. The migration must go live next week and production availability cannot be impacted. Design the migration approach and the backfill strategy.

Summary

Add and backfill a new column to a billion-row production table with zero downtime.

Practice This Problem

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