CODEWITHSUNDEEP
sqlgoogle-bigquery
1stenjoydmoment
1stenjoydmoment

Reputation: 249

Not able to create a table with JSON datatype in Bigquery

I am trying to create a table in Bigquery with Json data type and getting below error

CREATE TABLE mydataset.table1(
  id INT64,
  cart JSON
);

Error :

Error running query
Type not found: JSON at [4:8]

https://cloud.google.com/bigquery/docs/reference/standard-sql/json-data

Is this Supported in Bigquery ?

Upvotes: 0

Views: 596

Answers (1)

Cylldby
Cylldby

Reputation: 1978

The JSON is unfortunately not Generally Available yet

This product or feature is covered by the Pre-GA Offerings Terms of the Google Cloud Terms of Service. Pre-GA products and features might have limited support, and changes to pre-GA products and features might not be compatible with other pre-GA versions. For more information, see the launch stage descriptions.

But apparently in order to test it you can try to apply:

To enroll in this preview, complete the enrollment form.

Upvotes: 1

Related Questions