Why is it important to use ref() instead of hardcoding table names when sharing models across teams in dbt?

hard🧠 Conceptual Q10 of 15

dbt - Governance and Collaboration

Why is it important to use ref() instead of hardcoding table names when sharing models across teams in dbt?

AHardcoded names prevent accidental changes

BHardcoding table names improves performance

C<code>ref()</code> is only for internal models, not cross-team sharing

D<code>ref()</code> maintains dependencies and enables automatic recompilation when models change

Step-by-Step Solution

Solution:

Step 1: Understand the role of ref() in dbt
ref() creates model dependencies and ensures dbt knows the relationships.
Step 2: Explain benefits for cross-team sharing
Using ref() allows automatic recompilation and correct build order when models change, which hardcoding breaks.
Final Answer:
ref() maintains dependencies and enables automatic recompilation when models change -> Option D
Quick Check:
ref() manages dependencies correctly [OK]

Quick Trick: Always use ref() to keep model dependencies intact [OK]

Common Mistakes:

MISTAKES

Master "Governance and Collaboration" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes