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.
Extract, Transform, Load (ETL)
Pull data out. Clean it on the way. Then load it in.
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.
Extract, Load, Transform (ELT)
Load the raw data first. Then clean it in the warehouse.
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.
In one line
- Extract, Transform, Load (ETL)
- Pull data out. Clean it on the way. Then load it in.
- Extract, Load, Transform (ELT)
- Load the raw data first. Then clean it in the warehouse.