Currently my company uses two bigquery projects, one dev and one prod and our dbt dev work is done in dev and pushed through to prod with PRs. We are now going to have 3 projects: dev, staging, and prod. where staging will contain robot testing data while prod will contain only production data and dev will just have samples of all the sources for dev work. What used to be our old dev BQ project is becoming our staging project and we just created a new project for dev work. I want the exact same models between all the projects so I would just like to figure out how to make it so that my workflow is as follows:
I do dev work in the new dev project → Make a PR and merge → dbt run commences in staging → dbt run commences in prod
This way I can do dev work in the project without any important data and then our staging and production environments will hold the same models but with different data that we can then use however we want in bigquery