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

005·75

transformation

/ˌtræns.fər.ˈmeɪ.ʃən/ - n.

1 [colloq.] Where the business logic lives, defined by whoever happened to write the join and unavailable for comment.Keep. Punchy.This is the problem.

Working definition

2. The step in a pipeline that applies business logic to reshape, clean, join, or aggregate raw data into a form fit for analysis.

Promoted
Seen in the wild · 3
See also
  • business logic driftThe slow distance between what the query computes and what anyone still means by it, measured in pull requests no one reviewed.
  • 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.