PRODUCTION FLOWSTransform

ETL vs ELT

How data moves in production — pick a topic on the left and its full breakdown loads here: the mental model, real pipeline diagrams and worked examples, failure modes, and the habits that keep data flowing correctly and on time.

⏱ 18 min readTopics chapter readerLevel · Foundations
01 · Orientation

What You'll Master Here

Moving house — the truck and the new house never change; only whether you unpack at the curb, or later once everything’s inside, does.

⏱ 5 min · Topic 1 of 11

Extract, Transform, Load — three jobs. The only question in this chapter is whether the transform happens before the data reaches the warehouse (that is ETL) or after it gets there (ELT). Nothing else about the order changes.

Everything else people blame on the order — keeping raw data, cost, who is allowed to build pipelines — travels with it out of habit, not because the order causes it. Separating those two groups is the whole chapter.

Six claims below. Commit to each before reading on, and expect to get some wrong; that is what makes the reveal worth reading.

Core mental model

Moving house — the truck and the new house never change; only whether you unpack at the curb, or later once everything’s inside, does.

Why it matters

Treating bundled decisions as caused by the order turns "ELT good, ETL old" into superstition.

Six claims about ETL/ELT — place a verdict and a confidence on eachExactly two of these six are decided by the order of the letters. Most readers pick four or five.0/6 committed
  • 1. Which engine executes the transform.
    Left unset counts as Hedging when you reveal.
  • 2. Whether you still hold the raw rows next month.
    Left unset counts as Hedging when you reveal.
  • 3. Whether an analyst who only knows SQL can build the pipeline.
    Left unset counts as Hedging when you reveal.
  • 4. Whether the destination enforces a schema on write.
    Left unset counts as Hedging when you reveal.
  • 5. Whether the raw rows the transform read cross into the warehouse as the load itself.
    Left unset counts as Hedging when you reveal.
  • 6. Which of ETL or ELT costs less on the cloud bill.
    Left unset counts as Hedging when you reveal.
Common mistake

Believing ELT is simply "better" than ETL in every case. You apply it where audit scope, ownership, or capability calls for the other order.

Better habit

Separate the three jobs from the four bundled decisions.

Ask which engine pays for the transform.

Treat ETL and ELT as tools per dataset, never a tribe.

The big idea

The order decides one thing — which engine executes the transform. Everything else travels with it by habit, not cause.

How to study this chapter

Lock in your six wagers above before reading on — the panel only means something if you committed first.

Remember this

One letter order, one consequence: which engine executes the transform. Everything else rides along by habit.

Practice2 prompts
  1. State what the ETL/ELT order actually decides.
  2. Name two things people wrongly attribute to the order that are actually independent.