# A daily revenue pipeline runs from a cron entry on a developer's laptop: bash dumps a CSV, scp moves

Canonical URL: <https://datadriven.io/problems/a-daily-revenue-pipeline-runs-from-a-cron-entry-on-a-develop-0929ca43>

Domain: Pipeline Design · Difficulty: medium

## Problem

A daily revenue pipeline runs from a cron entry on a developer's laptop: bash dumps a CSV, scp moves it, a Python script loads Snowflake, then emails a Looker URL. When the laptop sleeps the pipeline silently fails; SSH timeouts overwrite the previous good CSV; there are no retries or dependency tracking. Apply the section's DAG framing and convert this to a real orchestrated pipeline.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/a-daily-revenue-pipeline-runs-from-a-cron-entry-on-a-develop-0929ca43)
- [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.