[Solved] Identify the error in this dbt for loop snippet:{% for col in columns %}SELECT {{ col }} FROM users{% endfor %}Assuming columns = ['id', 'name']. | dbt

dbt - Jinja in dbt

Identify the error in this dbt for loop snippet:

{% for col in columns %}SELECT {{ col }} FROM users{% endfor %}

Assuming columns = ['id', 'name'].

AWrong loop syntax with {{ }} instead of {% %}

BMissing UNION ALL or separator between SELECT statements

CIncorrect variable name inside the loop

DLoop variable should be capitalized

Step-by-Step Solution

Solution:

Step 1: Analyze the loop output
The loop outputs two SELECT statements back to back without any separator.
Step 2: Identify missing SQL syntax
Without UNION ALL or a separator, the SQL is invalid and will cause errors.
Final Answer:
Missing UNION ALL or separator between SELECT statements -> Option B
Quick Check:
Multiple SELECTs need UNION ALL [OK]

Quick Trick: Add UNION ALL between selects in loops [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Identify the error in this dbt for loop snippet: