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
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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2020-04-30 11:50:08 |
Date Created: | 2020-04-27 15:21:50 |