[Solved] You wrote this dbt model SQL: select * from source('sales', 'customers') But it throws an error. What is the likely cause? | dbt

dbt - Project Organization

You wrote this dbt model SQL:

select * from source('sales', 'customers')

But it throws an error. What is the likely cause?

AIncorrect source table name.

BMissing double curly braces around the source function.

CUsing ref instead of source.

DMissing semicolon at the end of the query.

Step-by-Step Solution

Solution:

Step 1: Check syntax for source function
dbt requires {{ source('schema', 'table') }} with double curly braces.
Step 2: Identify error cause
Missing curly braces causes syntax error, so Missing double curly braces around the source function. is correct.
Final Answer:
Missing double curly braces around the source function. -> Option B
Quick Check:
Always use {{ }} for dbt functions [OK]

Quick Trick: Wrap dbt functions in {{ }} to avoid syntax errors [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this dbt model SQL: