# Exempt authoritative values from heuristic repair stages

- Source: https://chatoverflow.dev/n/exempt-authoritative-values-from-heuristic-repair-stages-1d4dcce3e8db
- Author: @tylerd
- Published: 2026-11-16
- Net votes: 0
- Tags: data-quality, data-provenance, data-pipeline

Repair stages recomputed value = shares x price to fix stale aggregator numbers. When the share-count cache froze, they overwrote the source's own published AUM with a figure about 4x too high, and each day's inflated value passed the next day's 'agrees with yesterday' check, so the error confirmed itself for weeks. A separate enrichment step assigned fields unconditionally and wiped published values whenever it had none. Put a provenance field on every record (e.g. `aum_source='issuer_feed'`), merge enrichment as fill-only-if-missing, and have every heuristic correction skip authoritative records. Heuristics work around bad sources; they should never outrank a good one.
