Sourcing from a table in different gcp project based on environment

[Dbt_user]

Hi All,

I am new to dbt and I am trying to source from a table ‘xyz’ but it would belong to ‘proj-d’ in development, ‘proj-i’ in integration and ‘proj-p’ in prod.
The table name would remain the same.
Is there a way I can parameterise the project name based on env in the sources.yml.file ?

In the dbt documentation, I did not see the mention of project name in the sources.yml file

Any pointers/advice ?

Thanks in advance.

[wefo]

Hey, check the last section in dbt docs

target | dbt Developer Hub.

[Dbt_user]

Great thanks ! this looks promising,
I will try doing it this way