# Extract, Transform, Load (ETL)

> Pull data out. Clean it on the way. Then load it in.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** ETL, ETL Pipeline

## Think of it like

It is like washing fruit at the farm. Then you put it in the fridge.

## Definition

ETL is a way to move data in three steps. Extract reads the data from its source. Transform cleans and reshapes it on a separate server. Load writes the finished data into the warehouse. Only clean data ever reaches the warehouse. It was the usual way when warehouse space cost a lot.

## Example

A hospital pulls out each day's visits at night. It takes out the names. Only the clean rows go into the report tables.

## Why it matters

Cleaning first keeps raw and private data out of the warehouse. It also keeps the warehouse small.

## Common mistake

Thinking ETL and ELT are the same thing. The order changes where the work runs and what gets kept.

## Three principles

- **Extract.** Read the data from the source.
- **Transform.** Clean it before it lands.
- **Load.** Write only the finished data.

## Related terms

- [Extract, Load, Transform (ELT)](https://learn.benibix.com/term/data/elt)
- [Data Pipeline](https://learn.benibix.com/term/data/data-pipeline)
- [Data Integration](https://learn.benibix.com/term/data/data-integration)
- [Reverse ETL](https://learn.benibix.com/term/data/reverse-etl)

## Told apart from

- [ETL vs ELT](https://learn.benibix.com/compare/etl-vs-elt): People think ETL and ELT are two names for one thing. They use the same three steps in a different order. ETL cleans data on a separate server before it lands. ELT loads raw data first and cleans it inside the warehouse with SQL. That choice decides what gets stored and where the work runs.

## Taught in

- [ETL, ELT and Reverse ETL](https://learn.benibix.com/learn/data-foundations/etl-elt-and-reverse-etl): Data Engineering Basics, 4/11

![Two rows of three steps. The ETL row runs extract, transform, load, so data is cleaned before it reaches the warehouse. The ELT row runs extract, load, transform, so raw data lands first and is cleaned inside the warehouse.](https://learn.benibix.com/diagrams/etl-vs-elt.svg)

---

Source: https://learn.benibix.com/term/data/etl
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
