[Solved] What will be the output SQL of this dbt snippet?{% set tables = ['orders', 'customers'] %} SELECT '{{ tables[1] }}' AS table_name | dbt

dbt - Jinja in dbt

What will be the output SQL of this dbt snippet?

{% set tables = ['orders', 'customers'] %}
SELECT '{{ tables[1] }}' AS table_name

ASELECT 'customers' AS table_name

BSELECT 'orders' AS table_name

CSELECT tables[1] AS table_name

DSELECT {{ tables[1] }} AS table_name

Step-by-Step Solution

Solution:

Step 1: Understand list indexing in Jinja
Lists start at index 0, so tables[1] is 'customers'.
Step 2: Variable insertion in SQL
The variable is inserted inside quotes, so the output is 'customers'.
Final Answer:
SELECT 'customers' AS table_name -> Option A
Quick Check:
List index 1 = 'customers' inserted as string [OK]

Quick Trick: Jinja lists start at 0; index 1 is second item [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

What will be the output SQL of this dbt snippet?