When you set the Google BigQuery LIBNAME option USE_INFORMATION_SCHEMA to YES, activities that need to list tables in the library might return no tables. 

This issue is typically encountered with the following:

• the DATASETS procedure
• expanding a LIBRARY to show the tables (For example, if you select Libraries in SAS^® Studio and expand a Google BigQuery library.)

This issue has been observed when all of the following are true:

• The schema name contains an underscore (_).
• The Google BigQuery data set (schema) Data location is not in the US.
• The LIBNAME option USE_INFORMATION_SCHEMA=YES is set.

Note: Beginning with SAS^® Viya^® 2020.0.5, the default value for USE_INFORMATION_SCHEMA was changed to YES.

The only workaround is to set the LIBNAME option USE_INFORMATION_SCHEMA=NO.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.43 is available at: