# Extract, Load, Transform (ELT)

> Load the raw data first. Then clean it in the warehouse.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** ELT

## Think of it like

It is like putting all the food in the fridge first. You wash each thing when you need it.

## Definition

ELT uses the same three steps as ETL, in a new order. Extract reads the data from its source. Load writes it, raw, straight into the warehouse. Transform then reshapes it inside the warehouse, using SQL. This became common once cloud warehouses got cheap and fast. The raw copy stays, so you can transform it again later.

## Example

A startup loads raw app events into BigQuery each hour. Then analysts write SQL. It turns them into a count of users per day.

## Example code

```sql
CREATE TABLE clean_orders AS
SELECT id, LOWER(email) AS email, total
FROM raw_orders
WHERE total > 0;
```

The transform step. It runs as SQL in the warehouse, on rows that came in raw.

## Why it matters

The raw data is kept. So when you fix a bug, you do not need to go back to the source.

## Common mistake

Loading raw data and never cleaning it. ELT moves the transform step, it does not remove it.

## Three principles

- **Load first.** Raw data lands just as it is.
- **Transform in place.** SQL runs inside the warehouse.
- **Raw copy kept.** You can rebuild any table later.

## Related terms

- [Extract, Transform, Load (ETL)](https://learn.benibix.com/term/data/etl)
- [Data Pipeline](https://learn.benibix.com/term/data/data-pipeline)
- [Structured Query Language (SQL)](https://learn.benibix.com/term/development/sql)
- [Data Integration](https://learn.benibix.com/term/data/data-integration)

## 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/elt
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.
