fct_orders runs cleanly today with no observability beyond the orchestrator's run status and no cost

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

fct_orders runs cleanly today with no observability beyond the orchestrator's run status and no cost visibility. The section's instrumentation sequence delivers value at each step: pillar coverage on the output (freshness, volume, schema, distribution checks in dbt tests), lineage visibility (push the dbt manifest plus BI query history to a shared catalog), cost tags (Snowflake QUERY_TAG with pipeline_id and run_id), then a runbook for the new alerts. Sequence the instrumentation by adding the four steps in order on the canvas, each with what it adds and the value it delivers before the next step starts.

Practice This Problem

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