A subscription company runs Postgres signups -> daily Python ETL -> Snowflake daily_signups_by_count

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

A subscription company runs Postgres signups -> daily Python ETL -> Snowflake daily_signups_by_country -> Looker. Marketing then asks for the chart redrawn under a new country grouping for the last 18 months. The team kicks off a backfill and discovers Postgres holds only the last 90 days. Apply the section's four-layer framing and add the missing layer that would make the 18-month backfill possible.

Practice This Problem

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