Usage Note 65885: The ability to connect to a Google BigQuery database via OAuth Authentication has been added to SAS/ACCESS® Interface to Google BigQuery
 |  |  |  |  |
The ability to connect to a Google BigQuery database via OAuth is now available with this hot fix. Three new options have been added, REFRESH_TOKEN=, CLIENT_ID=, and CLIENT_SECRET=. You can use these options with the following connection methods to the Google BigQuery database:
A utility has been created to generate the refresh token that is needed for OAuth authentication. This utility can be downloaded from the SAS/ACCESS to Google BigQuery Tools Downloads page. The ReadME file contains a link to usage information about the getRefreshToken utility.
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 |
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.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#65885| Type: | Usage Note |
| Priority: |
| Date Modified: | 2020-05-01 08:59:50 |
| Date Created: | 2020-04-27 15:45:13 |