Problem Note 70475: SAS/ACCESS® Interface to Google BigQuery does not support the JSON data type
 |  |  |  |
SAS/ACCESS Interface to Google BigQuery does not support the JSON data type. Trying to access a BigQuery table that contains a variable defined as a JSON data type results in an error. Here are some of the errors that have occurred due to this issue:
Table table_name does not exist or cannot be accessed
ERROR: unknown data type
ERROR: unknown data type
ERROR: Error: unknown datatype
ERROR: CLI prepare error: Table table_name does not exist or cannot be accessed Error: unknown datatype
The only workaround for this issue is to do either of the following:
- Use explicit pass-through and select all columns other than the JSON column.
- Use a JSON function to extract the values into strings or an array.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.4 TS1M9 | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | Stable 2023.11 | Viya platform | |
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-11-02 09:06:47 |
| Date Created: | 2023-10-27 13:15:13 |