dbt - Jinja in dbt
Which of the following is the correct way to insert a variable
start_date in a dbt SQL model using Jinja?Which of the following is the correct way to insert a variable start_date in a dbt SQL model using Jinja?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recognize Jinja variable syntax
Jinja uses double curly braces {{ variable }} to insert variables into SQL.Step 2: Match syntax to options
Only SELECT * FROM table WHERE date >= {{ start_date }} uses {{ start_date }} correctly inside the SQL query.Final Answer:
SELECT * FROM table WHERE date >= {{ start_date }} -> Option BQuick Check:
Jinja variable = {{ variable }} [OK]
Quick Trick: Use {{ variable }} to insert variables in Jinja [OK]
Common Mistakes:
MISTAKES- Using $ or : instead of {{ }} for variables
- Writing variable name without braces
- Confusing Jinja with SQL parameter syntax
Master "Jinja in dbt" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes