dbt - Jinja in dbt
How do you correctly reference a variable named
schema_name inside a dbt SQL model using Jinja?How do you correctly reference a variable named schema_name inside a dbt SQL model using Jinja?
easy📝 Conceptual Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall Jinja variable syntax
Variables in Jinja are referenced using double curly braces: {{ variable_name }}.Step 2: Apply to SQL context
To insert the value ofschema_namedynamically, use {{ schema_name }} in the SQL code.Final Answer:
SELECT * FROM {{ schema_name }}.table -> Option AQuick Check:
Only double curly braces denote variable substitution in Jinja. [OK]
Quick Trick: Use {{ variable }} to insert variables in Jinja [OK]
Common Mistakes:
MISTAKES- Using {% %} which is for control statements
- Using [[ ]] which is not Jinja syntax
- Using $ which is shell variable syntax
Master "Jinja in dbt" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes