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

dbt - Jinja in dbt

Identify the issue in this dbt for loop snippet:

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

Assuming columns = ['user_id', 'email'].

AThe loop generates multiple SELECT statements without UNION or separator, causing invalid SQL

BThe variable 'columns' is not defined in the loop

CThe syntax for the for loop is incorrect

DThe SELECT statement should use double curly braces around 'columns'

Step-by-Step Solution

Solution:

Step 1: Understand the loop output
The loop outputs multiple SELECT statements consecutively without combining them.
Step 2: Identify SQL validity issue
Multiple SELECTs without UNION or separator produce invalid SQL.
Step 3: Confirm other options
Variables and syntax are correct; the problem is missing UNION or separator.
Final Answer:
The loop generates multiple SELECT statements without UNION or separator, causing invalid SQL -> Option A
Quick Check:
Multiple SELECTs need UNION or separator [OK]

Quick Trick: Combine multiple SELECTs with UNION or separator [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 issue in this dbt for loop snippet: