[Solved] Given this snippet in dbt_project.yml: models: my_project: materialized: table schema: analytics What will be the materialization type and schema for models in the my_project namespace? | dbt

dbt - Project Organization

Given this snippet in dbt_project.yml:

models:
  my_project:
    materialized: table
    schema: analytics

What will be the materialization type and schema for models in the my_project namespace?

AMaterialized as views, schema is default

BMaterialized as tables, schema is analytics

CMaterialized as incremental, schema is analytics

DMaterialized as tables, schema is default

Step-by-Step Solution

Solution:

Step 1: Read the materialized setting under models.my_project
The setting materialized: table means models will be built as tables.
Step 2: Check the schema setting
The schema is explicitly set to analytics, so models will be created in that schema.
Final Answer:
Materialized as tables, schema is analytics -> Option B
Quick Check:
Materialized = table, schema = analytics [OK]

Quick Trick: Look for materialized and schema keys under models [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this snippet in dbt_project.yml: