Question
Design the backend of an enterprise dashboarding platform used by 10,000 internal users across many teams. Dashboards query 8 different data sources (a TSDB, a logs store, a SQL warehouse, a tracing backend, etc.). Requirements: dashboards with template/variable dropdowns that cascade (pick region → filters the cluster dropdown → filters panels), per-team access control so users only see permitted dashboards and data, and rendering for scheduled email/PDF reports. Design the query abstraction, variable resolution, access control, and the rendering path.
Clarify scale and constraints first. Propose a clean component breakdown, then go deep on the hard parts — data model, bottlenecks, consistency, failure modes — and name the trade-offs you are making.