materialized

Project file

dbt_project.yml

config-version: 2

models:
  <resource-path>:
    +materialized: <materialization_name>

Property file

models/properties.yml

version: 2

models:
  - name: <model_name>
    config:
      materialized: <materialization_name>

Config block

models/<model_name>.sql

{{ config(
  materialized="<materialization_name>"
) }}

select ...

Definition

Materializations are strategies for persisting dbt models in a warehouse. These are the materialization types built into dbt:

• ephemeral — ephemeral models are not directly built into the database
• table — a model is rebuilt as a table on each run
• view — a model is rebuilt as a view on each run
• materialized_view — allows the creation and maintenance of materialized views in the target database
• incremental — incremental models allow dbt to insert or update records into a table since the last time that model was run

You can also configure custom materializations in dbt. Custom materializations are a powerful way to extend dbt's functionality to meet your specific needs.