Three transforms write to three differently-shaped destinations: a time-partitioned daily_orders fac
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
Three transforms write to three differently-shaped destinations: a time-partitioned daily_orders fact, a current-state dim_customer table, and an operational daily_customer_summary an internal app reads sub-millisecond. All three currently use plain Snowflake INSERT INTO. Apply the section's quick decision rule per destination so each lands on the pattern that fits its access shape.
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