Save array to BigQuery

3
votes

I've just started on BigQuery, and I wonder whether I can work with arrays natively or should I use a json string instead. Array data type is not listed on big query as a supported type. I need to save an array (list) of users objects to BigQuery.

What's the currently best approach?

2
google-bigquery

2 Answers

5
votes

Array data type is not listed on big query as a supported type.

Yes, it is a supported data type. From the data types documentation:

An ARRAY is an ordered list of zero or more elements of non-ARRAY values.

0
votes

Array data type is not listed on big query as a supported type.

But, use RECORD data type.

https://cloud.google.com/bigquery/docs/nested-repeated