Bird
0
0

You wrote this dbt model to share data across teams:

medium📝 Debug Q14 of 15
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:
  1. Step 1: Check ref() usage rules

    ref() accepts only model names without schema or dot notation.
  2. Step 2: Identify error cause

    Using team_a.orders inside ref() causes syntax error; correct usage is just orders.
  3. Final Answer:

    You cannot use dot notation inside ref(); only model names are allowed. -> Option A
  4. Quick Check:

    ref() = model name only, no dots [OK]
Quick Trick: Use only model names inside ref(), no dots [OK]
Common Mistakes:
MISTAKES
  • Using schema or team prefix inside ref()
  • Confusing ref() with source()
  • Missing curly braces around ref()

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes