---
answer: direct
beat: system-design
source: 1 article · updated: November 14, 2026
---

Why ingest raw data into the lake before transforming it?

A raw copy is a single source of truth that you can reprocess when logic changes or a bug is found, without going back to the production database. Transform and denormalize in later stages, and send only clean, business-critical results downstream.

Answered in

From Sharded Postgres to a Data Lake: CDC, Hudi and Update-Heavy Workloads

Why warehouses struggle when most writes are updates, and how Debezium, Kafka, Hudi and Spark replaced 480 hourly connectors for 200 billion rows.

Crashtech Editorial November 14, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.