Problem Note 71034: Slow performance or errors might occur when gathering metadata about a BigQuery table
 |  |  |  |  |
Queries that require metadata about a BigQuery table to be gathered when using the SCANSTRINGCOLUMNS=YES LIBNAME or a data set option might result in a query being passed to the database where the entire table is being queried. This behavior can result in performance issues. It can also cause other errors related to the size of the results as described in SAS Note 71033 and SAS Note 68634.
The only workaround is to use explicit pass-through.
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 | ||
A 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#71034| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-11-05 09:08:23 |
| Date Created: | 2024-11-01 17:01:14 |