The problem I’m having
( I am new to dbt)
Im trying to determine how the deployment (creation) of shared models should be setup when there are two teams having their own dbt project and airflow instances. How to make sure which team sets up the airflow deployment and how to avoid conflicts.
I think, if the models are Views then even if both the teams setup the same model deployment, it shouldn’t affect much (apart from duplication of work). But table models may have issues.
What is the general recommendation to setup such shared repos. What to share what not to share and how to setup the deployment.
The context of why I’m trying to do this
We have two teams that have separate dbt and Airflow setup but deploy to the same data warehouse. In general we work on different schemas and models but we have a requirement where we want to share the underlying macros and models to build on top of another.
We are planning to adopt the Option-2 strategy as stated in the article for dbt mesh implementation.
What I’ve already tried
Still in setup mode.