ELT: Load Raw Data First, Transform It Later
ELT pipelines load raw data directly into a data lake *before* any transformation. This speeds up ingestion and lets you figure out the data's structure later.
Extract, Load, Transform (ELT) flips the traditional data pipeline by loading raw data directly into a data lake *before* any cleaning or structuring. This approach is ideal for big data scenarios where ingestion speed is critical and you don't need a predefined schema. It allows analysts to explore the raw data flexibly. The footgun is that transformations happen on-demand at query time, which requires a powerful processing engine to deliver results without significant delays.
Read the original → Wikipedia: Extract, load, transform
- #data engineering
- #data pipeline
- #elt
- #analytics
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.