The Register Never Sleeps

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

Domain

Pipeline Design

Difficulty

medium

Seniority

L5

Problem

We're a retail chain with 600 stores and a Snowflake data warehouse. Our POS terminals generate sales transactions in real time but right now they batch-upload to S3 at end of day, which means the operations team can't see intraday sales. Design a pipeline that gets POS data into Snowflake with low latency, while correctly merging with the historical data already in the warehouse.

Summary

Every swipe lands in the warehouse. The table has to stay current without breaking.

Practice This Problem

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