[Solved] Given this dbt_project.yml snippet:models: analytics: materialized: table schema: analytics_schemaWhat will be the schema and materialization of models under the analytics folder when run? | dbt

dbt - Project Organization

Given this dbt_project.yml snippet:

models:
  analytics:
    materialized: table
    schema: analytics_schema

What will be the schema and materialization of models under the analytics folder when run?

ASchema: default, Materialization: view

BSchema: analytics_schema, Materialization: view

CSchema: analytics, Materialization: table

DSchema: analytics_schema, Materialization: table

Step-by-Step Solution

Solution:

Step 1: Examine the provided snippet
The configuration under analytics lacks + prefix before materialized and schema.
Step 2: Understand dbt parsing
Without +, these are treated as directory names, not configs. Models use defaults: view materialization and default schema from profiles.yml.
Final Answer:
Schema: default, Materialization: view -> Option A
Quick Check:
Missing + = defaults apply [OK]

Quick Trick: Without + prefix, configs don't override defaults [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this dbt_project.yml snippet: