ETL ELT

Extract-Transform-Load vs Extract-Load-Transform: moving data between systems, and where the transform step should live.

Why we need this / what value this brings

Deciding where transformation happens (before or after loading) determines how much tooling and infra you need to maintain.

Once data needs to move from an operational store into a separate system (warehouse, another service) for a different purpose.

For a small team, ELT (load raw, transform with SQL/dbt in the warehouse) is usually less operational overhead than a dedicated ETL pipeline.

ELT (transform in the warehouse) vs ETL (transform before load) — which fits a small team's tooling better?

Empty folder — drop notes, links, and findings here as you research.