SUPPORT / SAMPLES & SAS NOTES
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
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 |