Knowledge Article View - Customer Support

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: 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.

Support was added with SAS Viya Platform Stable 2023.11 and SAS 9.4M8 (TS1M8).