Materializations: view vs table

By default dbt materializes every model as a view, but you can change that with {{ config(materialized="table") }} at the top of a model. Views are cheap to build but slow to query; tables are the opposite.

In this lesson you will toggle materializations between view and table, then inspect the warehouse to see how dbt rebuilds each model.