Trying to read a Google BigQuery table that contains a variable that is defined as an array of records might result in an error and cause SAS to shut down. This issue occurs when one of the variables contained in the record is also defined as an array of records. The error that is seen varies depending on how you are running SAS. Here are some examples:

• If you are running SAS^® 9.4M6 (TS1M6) through Display Manager, command line, or batch, the error written to the UNIX shell might look similar to one of the following:

• If you are using SAS^® Enterprise Guide^® to run SAS 9.4M6 (TS1M6), the above errors might not be seen. Instead, you might receive a pop-up window with an error similar to the following:

• If you are using SAS^® Studio to access SAS^® Viya^® (19w34) or later and are using a libref to access the BigQuery table, you might not receive any error that indicates that the code did not execute. The code that was submitted is not shown in the SAS Studio log.
• If you are using SAS Studio to access SAS Viya (19w34) or later and are using a CASLIB to access the Google BigQuery table, you might see an error similar to the following:

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

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