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:
ERROR: CLI prepare error: Error occurred during Post Optimization. : Error: googleapi: Error 403: Response too large to return.
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
SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.43 | 9.4 TS1M6 | 9.4 TS1M8 |
*
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.
The error is "...Error occurred during Post Optimization.: Error: googleapi: Error 403: Response too large to return. Consider setting allowLargeResults to true in your job configuration. For more details, see https://cloud.google.com/bigquery/troubleshooting-errors, responseTooLarge."
Type: | Problem Note |
Priority: | high |
Date Modified: | 2021-03-08 09:02:31 |
Date Created: | 2021-02-12 06:36:18 |