Same-Day Sales, Every Store

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

Our retail stores run point-of-sale terminals that generate transactions all day. The business intelligence team currently gets a nightly batch of sales data but they want same-day visibility. We also have years of historical sales in our Snowflake warehouse that needs to stay consistent with whatever we build. Design a pipeline to bring POS data into Snowflake in near-real-time.

Summary

The cash register data needs to be queryable by morning.

Practice This Problem

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