Course
dbt Analytics EngineerDeveloping dbt ModelsMaterializations
0%
Model to objectPage 1

Materializations

You already have the SQL for your dbt model. When dbt runs it, there’s another choice to make: should people query a view, or should dbt store the result in a table? In dbt, that choice is called the materialization.

Starting with views and tables

These two choices make the core idea easy to see. dbt also has materializations such as incremental and ephemeral; we’ll introduce them when they become useful.

Restoring your place