[Solved] If dbt_project.yml contains:models: my_project: +materialized: incremental staging: +materialized: viewWhat materialization will models in the staging folder have? | dbt

dbt - Project Organization

If dbt_project.yml contains:

models:
  my_project:
    +materialized: incremental
    staging:
      +materialized: view

What materialization will models in the staging folder have?

Aincremental

Bview

Ctable

Dephemeral

Step-by-Step Solution

Solution:

Step 1: Understand the inheritance of materialization
The parent folder my_project sets materialization to incremental by default.
Step 2: Check the override in staging folder
The staging folder overrides materialization to view.
Final Answer:
view -> Option B
Quick Check:
Child folder config overrides parent materialization [OK]

Quick Trick: Child folder settings override parent folder settings [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

If dbt_project.yml contains: