[Solved] What is the output SQL of this dbt snippet?{% for col in ['first_name', 'last_name', 'email'] %}{{ col }}{% if not loop.last %} | {% endif %}{% endfor %} | dbt

dbt - Jinja in dbt

What is the output SQL of this dbt snippet?

{% for col in ['first_name', 'last_name', 'email'] %}{{ col }}{% if not loop.last %} | {% endif %}{% endfor %}

Afirst_name last_name email

Bfirst_name, last_name, email

Cfirst_name | last_name | email

Dfirst_name; last_name; email

Step-by-Step Solution

Solution:

Step 1: Analyze the loop
The loop iterates over the list ['first_name', 'last_name', 'email'].
Step 2: Understand the output formatting
Each column name is output, and if it is not the last item, a ' | ' separator is added.
Step 3: Construct the output
Output will be: first_name | last_name | email
Final Answer:
first_name | last_name | email -> Option C
Quick Check:
Separator ' | ' appears between items except last [OK]

Quick Trick: Check loop.last to control separators [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

What is the output SQL of this dbt snippet?