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

005·75

elt

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

1 [colloq.] ETL, but the part nobody documented now runs where the compute bill can see it.Keep. Punchy.This is the problem.

Working definition

2. Extract, load, transform: raw data lands in the warehouse first and is reshaped in place, deferring transformation to the destination.

Filed
See also
  • data martThe version of the numbers a team built so it would stop having to agree with the other teams.
  • dbt modelA SQL file that turned a folder of opinions about 'revenue' into a folder of opinions under version control.
  • etlThree verbs, four teams, and no agreement on which one owns the part that broke.
  • transformationWhere the business logic lives, defined by whoever happened to write the join and unavailable for comment.