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

005·75

dbt model

/ˌdiː.biː.ˈtiː ˈmɒd.əl/ - n.

1 [colloq.] A SQL file that turned a folder of opinions about 'revenue' into a folder of opinions under version control.Keep. Punchy.This is the problem.

Working definition

2. A version-controlled SQL select statement that defines a transformation, materialized by dbt as a table or view with declared dependencies and tests.

Filed
See also
  • data martThe version of the numbers a team built so it would stop having to agree with the other teams.
  • eltETL, but the part nobody documented now runs where the compute bill can see it.
  • transformationWhere the business logic lives, defined by whoever happened to write the join and unavailable for comment.