CODEWITHSUNDEEP
google-bigquery
Mauricio
Mauricio

Reputation: 3139

Save array to BigQuery

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?

Upvotes: 4

Views: 7614

Answers (2)

nitinsridar
nitinsridar

Reputation: 696

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

Upvotes: -1

Elliott Brossard
Elliott Brossard

Reputation: 33765

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.

Upvotes: 6

Related Questions