Sixty Minutes, Every Hour

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

L6

Problem

We run an OLTP system that powers a customer-facing application, and the analytics team needs that data in the warehouse refreshed every hour without their queries ever touching the production database. The dashboards run a few minutes after each hour and can't see an hour where some tables have updated and others haven't, and when the pipeline is down for a stretch the catch-up run has to restore the warehouse without losing or double-counting rows.

Summary

Every hour, on the hour. No excuses.

Practice This Problem

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