Moment at 8:16 in I replaced my entire stack with Postgres... by The Coding Gopher.
To avoid the overhead of Snowflake or other data warehouses, **materialized views** save heavy aggregations to disk and can be updated in the background using the `REFRESH CONCURRENTLY` command
Saved by Arn D.