When you open a table with SAS Enterprise Guide 8.4, SAS^® Enterprise Guide^® 8.5, and SAS^® Enterprise Guide^® 8.6 in the SAS Enterprise Guide server or library list, or in the SAS Enterprise Guide Query Builder, errors occur when the table name is the same in both the concatenated libraries. 

You can access the same Google BigQuery table from the concatenated library using code within SAS Enterprise Guide. The errors occur only when the concatenated library contains a Google Big Query library. This issue does not occur in SAS^® Enterprise Guide^® 8.3 and earlier.

The errors occur when you access the Big Query table from the concatenated library and when the table name exists in both libraries in the concatenation.

When you navigate to the SAS Enterprise Guide Servers ► Libraries graphical user interface (the bottom left panel of SAS Enterprise Guide), the following error occurs:

Error: Cannot open data set “BQ_Tablename”. 

File LIBNAME.BQ_TABLENAME.DATA does not exist.

For data from a work library, rerun your code to rebuild the dataset.

Here is an example screenshot:

In the SAS Enterprise Guide Query Builder, the following error occurs:

Error: Unable to open input data.

Here is an example screenshot:

This issue occurs (and can be replicated) using code similar to the example BQconcat.sas example.

Resolution

To resolve this issue, update to SAS Enterprise Guide 8.6 Update 3 or later. 

Workaround

Note: The following workaround is not suitable for everyone.

To work around this issue, move the concatenated library creation before the View creation. This workaround might not be possible depending on when you created the Views or if the Views already exist.