dbt Materialization #
Materializations are how dbt models are persisted in a data warehouse (i.e., how do you want to store that data?).
Options are:
-
Table
-
View - this is the default
-
Incremental
-
Ephemeral
These can be adjusted in dbt_project.yml
...
models:
<model name>:
+materialized: view # or something else
+scheme: <schema definition>
example:
+materalized: table # or something else\
Then dbt run.
Alternateively, use a config macro at an individual model level. This is done by including the following snippet at the top of the model definition:
{{ config(materialized='table')}} # or something else