[Solved] You wrote this dbt model to share data across teams:select * from {{ ref('team_a.orders') }}But it fails with an error. What is the likely cause? | dbt

dbt - Governance and Collaboration

You wrote this dbt model to share data across teams:

select * from {{ ref('team_a.orders') }}

But it fails with an error. What is the likely cause?

AYou cannot use dot notation inside <code>ref()</code>; only model names are allowed.

BThe model <code>team_a.orders</code> does not exist in the project.

CYou forgot to wrap <code>ref()</code> in double curly braces.

DYou need to use <code>source()</code> instead of <code>ref()</code> for cross-team models.

Step-by-Step Solution

Solution:

Step 1: Check ref() usage rules
ref() accepts only model names without schema or dot notation.
Step 2: Identify error cause
Using team_a.orders inside ref() causes syntax error; correct usage is just orders.
Final Answer:
You cannot use dot notation inside ref(); only model names are allowed. -> Option A
Quick Check:
ref() = model name only, no dots [OK]

Quick Trick: Use only model names inside ref(), no dots [OK]

Common Mistakes:

MISTAKES

Master "Governance and Collaboration" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this dbt model to share data across teams: