An e-commerce startup has Postgres for the app, an empty Snowflake warehouse set up last quarter, an

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

An e-commerce startup has Postgres for the app, an empty Snowflake warehouse set up last quarter, and a Looker dashboard that still queries Postgres directly on every refresh. The dashboard is dragging the checkout API down each morning. Apply the section's three-gaps framing to close the gap between the operational source and the dashboard, refreshing once a day at 7am Pacific. Postgres must stay (the app still needs it).

Practice This Problem

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