Sourcing from a table in different gcp project based on environment

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.

Hey, check the last section in dbt docs

target | dbt Developer Hub.

1 Like

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

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.