A table derives aggregate results from mutable upstream data. Why consider a materialized view rather than append-only row ingestion?

1. Materialized views never consume compute
2. An append-only stream automatically retracts every source update
3. It maintains a query result over changing source data
4. Materialized views grant all source permissions automatically