Which of the following is the correct syntax to create a variable named my_var with value 10 in dbt?

easy📝 Syntax Q12 of 15

dbt - Jinja in dbt

Which of the following is the correct syntax to create a variable named my_var with value 10 in dbt?

A{% set my_var = 10 %}

B{% var my_var = 10 %}

C{{ set my_var = 10 }}

D{% set 'my_var' = 10 %}

Step-by-Step Solution

Solution:

Step 1: Recall dbt variable syntax
In dbt, variables are created using the Jinja syntax: {% set variable_name = value %}.
Step 2: Check each option
{% set my_var = 10 %} matches the correct syntax exactly. Options B and C use wrong keywords or delimiters. {% set 'my_var' = 10 %} incorrectly quotes the variable name.
Final Answer:
{% set my_var = 10 %} -> Option A
Quick Check:
Correct variable syntax uses {% set %} [OK]

Quick Trick: Use {% set var = value %} without quotes around var [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes