Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Problem: Currently I did not find a way to work with multiple dbt cloud projects from the same dbt cli.
In this specific case we have the same repository however there are different geos I want to run the code against.
Additonally, I want to enable pre-commit to run checks against multiple projects utilizing the same repo instead.

Feature: Adding a --project-id optional global flag to provide dbt cloud project_id during run-time and if there is already project-id in dbt_project.yml use the one provided via the flag.

Describe alternatives you've considered

On slack I got answer with dbt-switch repo which would work for our case. But I rather have something integrated within the dbt-core and used in the dbt-cli package.

Another alternative is providing new project-id ad-hoc in the project yml.

Who will this benefit?

Teams with the same repository/models however utilzing different platforms/ tenants, regions for data warehousing. It could be e.g. for different storage needs per geo. Those teams would be able to use one dbt-cli project (main) running against different project leveraging the same repo in dbt cloud platform.

Are you interested in contributing this feature?

Yes, I can. I have already the code in this PR. However I need some guidance on testing it.

Anything else?

No response