SUPPORT / SAMPLES & SAS NOTES
Problem Note 68312: "CLI prepare error....unknown data type" occurs when you read a Google BigQuery table that contains a variable with the BIGNUMERIC data type
 |  |  |  |  |
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:
ERROR: CLI prepare error: Table "db.Test" does not exist or cannot be accessed : Error: unknown data type
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Google BigQuery | Linux for x64 | V.03.04 | Stable 2024.04 | Viya | Viya |
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.4 TS1M6 | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | Stable 2024.04 | Viya | Viya |