dbt Materialization

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

Table #

View #

Incremental #

Emphemeral #