Skip to main content




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.