A breaking schema change has been filed: the users table renames signup_date to created_at and chang

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

A breaking schema change has been filed: the users table renames signup_date to created_at and changes its type from DATE to TIMESTAMP. Twelve downstream consumer teams read this column. A flag-day deploy is impossible. The section's pattern is expand-contract in four phases: expand (add new shape, keep old), dual-write (populate both for every event), migrate (cut consumers over to new shape one at a time), and contract (drop old shape after every consumer has migrated). Order the phases on the canvas by adding four phase-marker nodes between the producer and the consumers, named so each marker states which phase it represents and what the producer and consumers are doing at that phase.

Practice This Problem

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