The plain-English version
Two pipeline patterns: extract-transform-load performs transformation before loading, while extract-load-transform transforms after loading.
Why it matters
The location of transformation affects access, storage, validation, and operational responsibilities.
Let’s make it click
A pipeline can clean a CSV before loading it, or load raw records and create cleaned tables afterward.
Vibe Bro’s heads-up
The acronym alone does not establish data quality; define the transformations, rejected-record handling, and checks explicitly.
The docs behind it
Documentation links checked .
Editorial review · October 28, 2026
Supported: ETL/ELT expansion and transformation-order distinction are correct; neither is presented as automatic quality assurance.