Flattened Tables vs Denormalized Tables vs Materialized Views: the Decision Guide, and How Incremental Flattened Tables Fixed Superset
Three patterns make a dashboard query cheap — a denormalized table, a materialized view, and a flattened snapshot table — and they look alike until one of them takes the production database down. Measured story: a BI tool with stored-SQL virtual datasets was pushing 961 MB/s of buffer traffic into a shared primary from two open browser tabs. This post is the decision guide (including where each pattern breaks, and a rank-by-measurement rule for choosing) plus the production fix that took dashboards off the primary entirely: a dedicated reporting database, a resource-restricted ETL role, and incremental 15-minute refresh that recomputes only what changed.
16 min