Materializations

Materialization defines how dbt builds a model in the warehouse: view (stored query), table (result recomputed on every run), incremental (only new rows are processed) or ephemeral (code inserted into the models that use it). The choice trades off read speed, cost and freshness.

Example

{{ config(materialized='table') }}
select * from {{ ref('stg_ventes') }}

Related concepts

The whole glossary