Problem Note 67421: A query against Google BigQuery tables might result in the message "...Error: googleapi: Error 403: Response too large to return..."
 |  |  |  |  |
If you run a query against a large Google BigQuery table, and you use the SCANSTRINGCOLUMNS= LIBNAME statement option, a message that is similar to the following error appears:
Consider setting allowLargeResults to true in your job configuration. For more details, see
https://cloud.google.com/bigquery/troubleshooting-errors, responseTooLarge
The error can occur when you run any query, including DATASETS and CONTENTS procedures, against a BigQuery table.
The only workaround is to set the option as SCANSTRINGCOLUMNS=NO.
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.43 | 9.4 TS1M6 | 9.4 TS1M8 |
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#67421A 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#67421| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-03-08 09:02:31 |
| Date Created: | 2021-02-12 06:36:18 |