Bird
0
0

A team shares a model but forgets to add it to the dbt_project.yml under the correct schema. What issue might occur?

medium📝 Debug Q7 of 15
dbt - Governance and Collaboration
A team shares a model but forgets to add it to the dbt_project.yml under the correct schema. What issue might occur?
AThe model will run but produce incorrect data
BThe model may not be found during compilation, causing errors
CThe model will be duplicated in the database
DNo issues; dbt ignores schema settings
Step-by-Step Solution
Solution:
  1. Step 1: Understand the role of dbt_project.yml

    This file defines model locations and schemas. Missing entries can cause dbt to not find models.
  2. Step 2: Predict the impact of missing schema config

    dbt will fail to compile models that are not properly configured in the project file.
  3. Final Answer:

    The model may not be found during compilation, causing errors -> Option B
  4. Quick Check:

    Missing schema config = compile error [OK]
Quick Trick: Always configure models in dbt_project.yml [OK]
Common Mistakes:
MISTAKES
  • Assuming schema config is optional
  • Expecting silent failures
  • Thinking data will be incorrect but model runs

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes