Problem Note 71033: Reading a Google BigQuery view based on an extremely large table might fail with "Error 403: Response too large to return error..."
 |  |  |  |  |
Trying to read a Google BigQuery view that is based on a extremely large table might fail with the following error:
ERROR: CLI prepare error: Error occurred during Post Optimization. : Error: googleapi: Error 403: Response too large to return.
Consider specifying a destination table in your job configuration. For more details, see
https://cloud.google.com/bigquery/troubleshooting-errors, responseTooLarge
Consider specifying a destination table in your job configuration. For more details, see
https://cloud.google.com/bigquery/troubleshooting-errors, responseTooLarge
The error occurs when the SCANSTRINGCOLUMNS=YES LIBNAME or data set option is specified.
The issue does not occur with the following scenarios:
- with SCANSTRINGS=YES while querying a large BigQuery table
- with SCANSTRINGCOLUMNS=NO while querying either a large BigQuery table or a view based on a large BigQuery table
There is no workaround for this issue.
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.42 | 9.4 TS1M7 | ||
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | 2020.1.1 | Viya platform | ||
A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M7Z.html#71033A 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#71033| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-11-05 09:07:06 |
| Date Created: | 2024-11-01 15:35:48 |