API-driven Materialization & Pre-aggregation for Fast BI Queries

Design materialized tables and pre-aggregations that power sub-second BI API endpoints with controlled freshness and low warehouse cost.