[Solved] You wrote this dbt model for source table products: select * from source('inventory', 'products') But dbt throws an error. What is the problem? | dbt

dbt - Project Organization

You wrote this dbt model for source table products:

select * from source('inventory', 'products')

But dbt throws an error. What is the problem?

AModel file name does not match source table

BWrong source table name

CMissing double curly braces around the source function

DUsing select * is not allowed

Step-by-Step Solution

Solution:

Step 1: Check dbt source function syntax and identify issue
The source function must be wrapped in double curly braces: {{ source(...) }}. The model uses source(...) without {{ }}, causing a syntax error.
Final Answer:
Missing double curly braces around the source function -> Option C
Quick Check:
dbt functions need {{ }} [OK]

Quick Trick: Always wrap dbt functions in {{ }} [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 for source table products: