SAS/ACCESS^® Interface to Google BigQuery does not support the BIGNUMERIC data type. When you attempt to read in a BigQuery table that contains a variable that is defined with a BIGNUMERIC data type, an error similar to the following occurs:

The same error might occur with a Google BigQuery table that contains a variable that is defined as a NUMERIC data type. For more information about this issue, see SAS Note 64859, "CLI prepare error....unknown data type" occurs when you read a Google BigQuery table that contains a variable with the NUMERIC data type.

The only workaround is to use explicit pass-through to read the table, either not selecting the column or casting the column to a supported data type.

Operating System and Release Information