Skip to content
BENIBIX Learn

Extract, Transform, Load (ETL)

Data🧭 FoundationsData Pipelines

Also known as ETL, ETL Pipeline

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

Think of it like

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

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.

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.
Same three steps, different order. The order decides where the cleaning happens.

Common mistake

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

Key takeaways

  1. 1
    Extract. Read the data from the source.
  2. 2
    Transform. Clean it before it lands.
  3. 3
    Load. Write only the finished data.

Compare

Learn it properly