I’m a newbie. And I have a question about using multiple BigQuery datasets (or projects).
dbt means by “warehouse” as “BigQuery: a single BigQuery account, with access to one or more projects”. So in the documents, it just shows how to config and work with one dataset only.
My scenario is as shown below.
In the same project of bigquery, I have multiple datasets of data sources e.g. recurly, saleforces, …
and a dataset for transformed data e.g. edw.
Is it possible in dbt project when using multiple BigQuery datasets (or multiple BigQuery projects)? If so, please let me know how to configure in profiles.yml and give me a sample model using these configs.
I’m looking forward to hearing from you.