Skip to content
Vol. I · No. 251
Mon · 8 Jun
A Daily Lexicon of Trustworthy Data
The Lexicon

005·75

etl

/iː.tiː.ˈɛl/ - n.

1 [colloq.] Three verbs, four teams, and no agreement on which one owns the part that broke.Keep. Punchy.This is the problem.

Working definition

2. Extract, transform, load: a pattern that moves data from source systems, reshapes it, then writes it to a destination warehouse.

Promoted
See also
  • eltETL, but the part nobody documented now runs where the compute bill can see it.
  • orchestrationThe discipline of deciding which job runs first, now practiced by three tools that each believe they are in charge.
  • pipeline ownershipA field in the catalog set to the name of someone who left in March.
  • transformationWhere the business logic lives, defined by whoever happened to write the join and unavailable for comment.