A clickstream pipeline lands billions of raw mobile-event JSON records straight into Snowflake at $2
A medium Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- medium
Interview Prompt
A clickstream pipeline lands billions of raw mobile-event JSON records straight into Snowflake at $23/TB/month. The volume is approaching petabyte scale and warehouse storage costs are becoming absurd. Apply the section's data-lake framing and split the storage by zone so the bulk raw volume lives in the shape the section names for cheap immutable retention, with the warehouse loading only the curated mart.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision