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 grading.

Domain

Pipeline Design

Difficulty

medium

Seniority

L5

Problem

Our Snowflake analytical queries ran in seconds when the underlying tables were small. Now that the tables have grown to terabyte scale, the same queries take minutes. Design the performance remediation plan and the query optimization architecture that resolves the bottleneck without migrating off Snowflake.

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 grades it automatically.