SAS Enterprise Connectivity to Google BigQuery

[PhatRam33]

The company that I work for is in the process of migrating data over to Google Cloud Platform on Google BigQuery and would like to see if it is possible to use SAS Enterprise Guide to connect to a database that has been migrated over to BigQuery from current server. I am hoping it is just a matter of changing the connection string and allowing me to use my existing code in my sas project.  I did some digging and it looks like SAS Viya will need to be utilized however, not sure how this comes in play with SAS EG or would we have to migrate code over to SAS Viya completely.  Any insight would be greatly appreciated.  

[SASKiwi]

SAS EG isn't supported in the latest version of SAS VIya - Viya 4, you have to switch to SAS Studio. What SAS/ACCESS products do you have? You can check by running this:

proc product_status;
run;

If you have SAS/ACCESS Interface to ODBC and a Google BigQuery ODBC driver that might be a possibility.

This looks like the best option: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0bm9s8t6t6rr2n1qgkamlgtb0kk.htm