The Query That Used to Be Fast

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant feedback.

Domain

Pipeline Design

Difficulty

medium

Seniority

L5

Problem

Analysts run interactive dashboards against a 2TB Snowflake fact table that used to answer in seconds; now the same date-filtered and merchant-filtered queries take minutes and blow past the 30-second interactive SLA. Design the remediation: give those dashboards a served surface fed from the warehouse, and stand up a scheduled job that tracks p95 query duration and pages the team when performance regresses, all within the CFO's cost ceiling.

Summary

Queries used to be fast. Something changed.

Practice This Problem

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