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

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to Google BigQuery (on SAS Viya)	Linux for x64	Viya platform

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

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#70326

---

USE_INFORMATION_SCHEMA=YES normally improves performance when getting a list of tables from Google BigQuery. But, in certain circumstances, no tables are listed.

Type:	Problem Note
Priority:	high

Date Modified:	2023-10-10 10:08:28
Date Created:	2023-08-16 08:30:58