In SAS^® Enterprise Guide^®, opening a Google BigQuery view might trigger an error similar to the following:

The error might occur when the following is true:

• The BigQuery view is registered in SAS^® Management Console.
• The library definition in SAS Management Console includes the SCANSTRINGCOLUMNS=YES option.
• SAS Enterprise Guide has a limit defined for the Maximum number of rows to display in the data grid with SAS/ACCESS data option under Tools ► Options ► Data ► Performance.
• The view includes at least one column defined as the STRING data type or at least one column defined as a RECORD data type and that variable contains at least one column defined as a STRING data type.
• The number of rows that result from processing of the view is more than the limit set in SAS Enterprise Guide.

With SCANSTRINGCOLUMNS=YES, the actual maximum length for a STRING column is determined. This measurement is the length that is registered in the metadata as the length for that column. This length is determined for every STRING column. When the view is opened in SAS Enterprise Guide, the defined limit set in SAS Enterprise Guide might be surfaced to the database and only those rows would be used to determine the length for each STRING column. The error occurs if the length for any of the STRING columns in the subset differs from what is registered in SAS Management Console. This issue occurs when any STRING column in the subset does not contain at least one row that has a value whose length is equal to the registered length.

The only workaround is to change the SAS Enterprise Guide setting to No Limit.