The daily_active_users SQL transform filters with WHERE event_ts >= NOW() - 1 day and runs from a ma

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

The daily_active_users SQL transform filters with WHERE event_ts >= NOW() - 1 day and runs from a manual cron. Reading the same logical date twice produces different results, and next month's backfill is impossible because NOW() will have advanced. Apply the section's fix: replace the wall clock with a parameter supplied by an orchestrator at bind time.

Practice This Problem

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