dbt - Governance and Collaboration
Which of the following is the correct way to reference another model in a dbt SQL file?
Which of the following is the correct way to reference another model in a dbt SQL file?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall dbt ref syntax
dbt uses the Jinja function ref() inside double curly braces to reference models.Step 2: Match syntax with options
SELECT * FROM {{ ref('model_name') }} uses the correct syntax: {{ ref('model_name') }} inside SQL.Final Answer:
SELECT * FROM {{ ref('model_name') }} -> Option CQuick Check:
dbt ref() = {{ ref('model') }} [OK]
Quick Trick: Use double curly braces and ref() to reference models [OK]
Common Mistakes:
MISTAKES- Omitting curly braces around ref()
- Using parentheses after model name
- Using incorrect variable syntax
Master "Governance and Collaboration" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes