dbt - Jinja in dbt
You want to create a shared macro library for multiple dbt projects. Which steps correctly set this up?
You want to create a shared macro library for multiple dbt projects. Which steps correctly set this up?
hard📝 Application Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Create shared macro project
Make a separate dbt project containing only macros you want to share.Step 2: Add as dependency
Publish this project and add it as a dependency in other projects via packages.yml.Step 3: Call macros by project name
Use the project namespace to call macros from the shared library.Final Answer:
Create a separate dbt project with macros, publish it, add as dependency in other projects -> Option BQuick Check:
Shared macro library = separate project + dependency [OK]
Quick Trick: Use a separate project and dependencies for shared macros [OK]
Common Mistakes:
MISTAKES- Copying macros manually causes duplication
- Defining same macros in multiple projects
- Using ref() for macros instead of models
Master "Jinja in dbt" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes