Problem Note 67616: A library created in SAS® Studio for a Google BigQuery database might not display any tables
 |  |  |  |  |
A libref for a Google BigQuery database might incorrectly show an empty table list if the library was created with the New Library dialog box within SAS Studio.
Currently, the USE_INFORMATION_SCHEMA LIBNAME option does not have a default value. However, SAS Studio expects that it has a default, so the check box for the option in the New Library dialog box is not selected. This causes the USE_INFORMATION_SCHEMA option to be set to NO. As a result, attempts to generate the list of BigQuery tables might result in an empty list.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix now sets the default for the USE_INFORMATION_SCHEMA option to YES.
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 TS1M6 | 9.4 TS1M8 | ||
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | 2020.0.5 | Viya | Viya |
A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#67616| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-06-29 16:47:03 |
| Date Created: | 2021-03-17 13:49:48 |