A two-person team has Stripe, a Python ETL, and a Looker dashboard wired straight to the ETL

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 two-person team has Stripe, a Python ETL, and a Looker dashboard wired straight to the ETL. Stripe rate-limits at 100 req/min while the dashboard refreshes 200 times a day, so every refresh re-pulls Stripe and trips the limit; when the ETL crashes mid-run the chart goes blank. Apply the section's four-roles framing and add the role the canvas is missing so the dashboard can refresh without retouching Stripe and keep serving when the ETL is down.

Practice This Problem

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