Problem Note 66996: The ability to use BigQuery Storage API has been added to SAS/ACCESS® Interface to Google BigQuery
 |  |  |  |  |
The ability to use BigQuery Storage API when reading from a Google BigQuery database is available with this hot fix. You can use the READ_MODE= option with the following methods of connection to the Google BigQuery database:
The ability to use the READ_MODE= data set option has also been added.
In order to use READ_MODE= option for Storage API, additional permissions on the service account or user ID might be needed. See the BigQuery documentation Predefined roles and permissions for the current list of required permissions.
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.41 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS Data Connector to Google BigQuery | Linux for x64 | V.03.05 | 2020.1.1 | Viya | Viya |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.05 | 2020.1.1 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K2L.html#66996A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#66996| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-12-07 09:00:36 |
| Date Created: | 2020-11-24 12:07:46 |