# A clickstream pipeline lands billions of raw mobile-event JSON records straight into Snowflake at $2 Canonical URL: Domain: Pipeline Design ยท Difficulty: medium ## Problem 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. ## Related - [All practice problems](https://datadriven.io/problems) - [Mock interview mode](https://datadriven.io/interview/a-clickstream-pipeline-lands-billions-of-raw-mobile-event-js-c8bb8d1c) - [System Design Interview Questions](https://datadriven.io/data-engineering-system-design) - [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep) - [Daily Challenge](https://datadriven.io/daily) --- Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.