SUPPORT / SAMPLES & SAS NOTES
Problem Note 65573: Reading in a BigQuery table might result in an error or slow performance
 |  |  |  |  |
When you read from a Google BigQuery table that includes a variable defined as a Boolean data type, a performance issue or an internal error similar to the following might occur:
ERROR: googleapi: Error 500: An internal error occurred
When a table contains a Boolean data type, any Read buffering performed is determined by the engine and not by any value provided in the READBUFF= option.
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.4 | 9.4 | 9.4 TS1M6 | 9.4 TS1M7 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | 2020.1 | Viya | Viya |