Our analytics warehouse had become the slowest part of the company. This is what we changed, in order, and what it cost.
Step one: delete
Forty percent of our models had no downstream consumer. Removing them cut compute spend before we optimised a single query.
Step two: contracts
Schema contracts between services stopped the silent breakages that had been eroding trust in every dashboard.
