Remote Tables & Federation

As of 2026-05-29

Federation = live SQL to remote source, no copy in DSP. Senior rule: < 5 % of volume, never dashboard sources. Wins on ad-hoc analyst queries, residency-strict reference data. Loses on joins > 100k rows, > 2 consumers/h, dashboards. Document federate-vs-materialize decision per table in ADR; reassess quarterly.