easy5 pts · first answer countsdata-warehousingdbt

View or table materialization

A dbt model is a heavy aggregation over 2 billion rows, and dashboards query it 500 times a day. Which materialization is the better default?

A.table, so the result is built once per runB.view, so it is always computed on readC.ephemeral, so it is inlinedD.seed, so it is loaded from CSV

Discussion 0

Join free to post in the discussion.