GREYBEARDroot since before you were born
field notes from the machine city
← Root & Echo
No. 024    Data · three spreadsheets that disagree about the same number

The Single Source of Truth

THE SINGLE SOURCE OF TRUTH

Three departments each keep the real customer count, and all three are certain. Echo proposes a single canonical table. Root agrees — and warns her the fight was never about the number; it's about who has to admit theirs was the lie.

Everyone wants one truth. No one wants to be the one who was wrong when it's chosen.

A scene Root & Echo

Three departments each had the real customer count, and the three real numbers did not agree.

Sales said 12,400. Finance said 11,950. The data team said 12,106, and was the most annoyed about it, because they were sure. Echo's proposal was sensible and doomed: one canonical table, one definition, everybody reads from it. "It's obviously the right thing. Why has no one done it?"

"Because the right thing requires two of them to be wrong in public," Root said, "and you've written a technical proposal for a political execution."

"It's not about ego. It's about correctness."

"It is entirely about ego, and pretending it isn't is how these die in committee." He set down his coffee. "Every one of those numbers has a person whose year is measured by it. Sales counts trials, because Sales is rewarded for trials. Finance excludes anyone who hasn't paid, because Finance answers to auditors. They're not wrong. They're answering different questions and calling the answer the same word. The fight isn't 'what's the count.' It's whose definition becomes the company's — and whose becomes the mistake."

"So how does it ever get done?"

"The way a king hunts." Root enjoyed her confusion for exactly one second. "Old line — the king drives the game on three sides and leaves the fourth open. He doesn't surround them. The ones who run, he lets run. You build the one table, and you make it so the other two don't have to die to join it: you keep their definitions in it, named, as views — Sales can still see 'Sales count,' Finance 'Finance count' — but all three sit on one set of rows underneath. Nobody has to stand up and say 'mine was the lie.' They just quietly start drinking from the same well, because you left them a way to come that doesn't cost them their face."

"That's not a data model. That's diplomacy."

"A single source of truth always is. The schema's the easy part. The hard part is building it so people can yield to it without bleeding."


What's happening here

The "single source of truth" project is almost never blocked by technology; it's blocked by politics. Departments compute the "same" metric differently because each definition serves a real incentive (Sales counts trials, Finance counts paid), so unifying them forces people to be wrong in public. The projects that succeed make yielding cheap: one set of underlying rows, with each group's definition preserved as a named view, so no one has to publicly admit theirs was the lie in order to join.

Inspired by Single source of truth.


The reading if you follow the I-Ching
䷇ → ䷁  Holding Together → The Receptive
line 5 changing
The king hunts using beaters on three sides only—game that escapes in front is allowed to go. This is holding together through freedom, not force. Those who come, come willingly. No warnings needed.

The figure. ䷇ Holding Together (Bǐ), line 5 changing → ䷁ The Receptive (Kūn). "The king hunts using beaters on three sides only; game that escapes in front is allowed to go." Union achieved through freedom, not force: those who come, come willingly, and no warnings are needed. Leave people a way to join that doesn't require their surrender.

The reading. A single source of truth is diplomacy, not schema. Everyone wants one truth; no one wants to be the one who was wrong when it's chosen — so build it to let them yield without bleeding. Drive three sides and leave the fourth open.

A story from @greybeard_root — field notes from the ruins of the machine city.
Department: Data ()
Next story: The Config That Got Everywhere