Hi all,
I am working on a project that uses a CDM instance hosted in BigQuery. Unfortunately, we have to run everything in a different BigQuery project the project containing the CDM instance. There is a bridge that allows us to query tables in the CDM project, and if we were running our own ad hoc SQL, we could simply add a prefix to the tables to reference the other project - e.g., instead of querying PERSON, we can write SQL to query ..PERSON…
Has anyone dealt with this situation before and have a workaround? Alternatively, does anyone know if there is a mechanism in CohortMethod for specifying a different project and dataset than the project in which we are running?
Thanks very much in advance for any help!
Regards,
Ken Jung