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

048·43

bridge table

/brɪdʒ ˈteɪbəl/ - n.

1 [colloq.] The table built to connect two things that were promised never to relate that way.Keep. Punchy.This is the problem.

Working definition

2. An intermediary table resolving a many-to-many relationship between a fact and a dimension, often carrying an allocation weight.

Evidence
See also
  • grainThe question 'what does one row mean?', asked far too late and answered by whoever wrote the query.
  • junk dimensionThe drawer where the model keeps every yes/no flag a stakeholder swore was critical and never queried.