Hey there, I’m pretty new to dbt but really excited to get started using it!
I’ve been playing around with a small dbt setup locally and have gotten a number of things up and running but am struggling on identifying the best solution for my use case.
For context, my company has multiple GCP projects, each of them having their own BigQuery instance with data and views that are sometimes custom and sometimes shared.
Two specific examples:
- Table A in project 1 is used as a source for view A in project 2
- View B is supposed to be created in project 1, project 2, and project 3 (where the view name and schema name is the same across all projects)
Ideally it’s one team that controls dbt for all these projects so with that in mind I’ve tried exploring a few potential solutions including:
- Multiple local dbt projects (one git repo)
- One dbt project using different databases (BigQuery projects)
Unfortunately with both of those solutions I’m running into issues. I’d really appreciate any guidance on thoughts for how to approach this.