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.
There is no workaround for this issue.
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 | Viya | ||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.4 | 9.4 TS1M6 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-08-27 15:16:09 |
| Date Created: | 2021-08-25 12:36:49 |