Finance found a rounding bug introduced 30 days ago in daily_revenue

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

Finance found a rounding bug introduced 30 days ago in daily_revenue. Today's run is correct; the last 30 days are off. They need a backward backfill replacing each day's partition. The pipeline reads NOW(), INSERTs into plain Snowflake, and has no orchestrator. Apply the section's four backfill prerequisites so the orchestrator can drive a clean loop over dates.

Practice This Problem

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