You want to configure dbt_project.yml so that all models in the core folder are materialized as tables, except those in core.temp which should be views. How should you write this?

hard📝 Application Q8 of 15

dbt - Project Organization

You want to configure dbt_project.yml so that all models in the core folder are materialized as tables, except those in core.temp which should be views. How should you write this?

Amodels: my_project: core: +materialized: view core.temp: +materialized: table

Bmodels: my_project: core: +materialized: table temp: +materialized: view

Cmodels: my_project: core.temp: +materialized: view core: +materialized: table

Dmodels: my_project: core: materialized: table core.temp: materialized: view

Step-by-Step Solution

Solution:

Step 1: Set default materialization for 'core' folder
Use core: with +materialized: table to set tables for all models in core.
Step 2: Override materialization for 'core.temp'
Inside core:, nest temp: with +materialized: view to override for that subfolder.
Final Answer:
models: my_project: core: +materialized: table temp: +materialized: view -> Option B
Quick Check:
Nested folder overrides override parent settings [OK]

Quick Trick: Nest subfolder config inside parent folder in YAML [OK]

Common Mistakes:

MISTAKES

Placing subfolder config at same level as parent
Using wrong indentation
Not using '+' for config overrides

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More dbt Quizzes

You want to configure dbt_project.yml so that all models in the core folder are materialized as tables, except those in core.temp which should be views. How should you write this?

Step 1: Set default materialization for 'core' folder

Step 2: Override materialization for 'core.temp'

Final Answer:

Quick Check:

Want More Practice?