SUPPORT / SAMPLES & SAS NOTES
Usage Note 65884: The ability to connect to a Google BigQuery database via proxy has been added to the SAS/ACCESS® Interface to Google BigQuery
 |  |  |  |  |
The ability to connect to a Google BigQuery database via a proxy is available with this hot fix. You can use the newly added option, PROXY=, with the following methods of connection to the Google BigQuery database:
LIBNAME GBQ BIGQUERY PROXY="<proxy_url>"...;
PROC SQL; CONNECT TO BIGQUERY(PROXY="<proxy_url>"...);
PROC FEDSQL NOLIB CONN=(DRIVER=FEDSQL;CONOPTS=(DRIVER=BIGQUERY;PROXY="<proxy_url>";...));
CASLIB GBQ DATASOURCE=(srctype="bigquery", PROXY="<proxy_url>",...);
Currently, after you make a connection to a BigQuery database (once the gbqgo.so library has been loaded), you cannot alter the PROXY= option without restarting the SAS session. This behavior includes when you add the PROXY= option after you attempted a prior connection to the BigQuery database without the option.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.42 | 9.4 TS1M6 | 9.4 TS1M7 |
| SAS System | SAS Data Connector to Google BigQuery | Linux for x64 | V.03.05 | 2020.1.1 | Viya | Viya |