# Raw events are dumped cheaply to object storage, but the BI team needs fast SQL aggregations over th

Canonical URL: <https://datadriven.io/problems/raw-events-are-dumped-cheaply-to-object-storage-but-the-bi-807ac841>

Domain: Pipeline Design · Difficulty: medium

## Problem

Raw events are dumped cheaply to object storage, but the BI team needs fast SQL aggregations over the cleaned data. Design storage that keeps raw data cheap AND gives BI a fast query surface.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/raw-events-are-dumped-cheaply-to-object-storage-but-the-bi-807ac841)
- [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.