Hacker News new | ask | show | jobs
by gerhardi 2146 days ago
Materialized views are also nice for many modern DW applications where you don't live in legacy "once in a hour/day/week" ELT/ETL environment, but more in a real timeish or micro batch world. You can have data marts / reporting tables composed with these materialized views over many kinds of underlying DW models. Just dropping this to promote the Materialized View functionality :)
1 comments

dbt (data build tool) is awesome for managing this.