16 September 2018 · Ryan-Dallas ·       Add to Favorites   Report

BigQuery How to return the first value of array?

In BigQuery, an array is an ordered list consisting of zero or more values of the same data type. You can construct arrays of simple data types, such as INT64, and complex data types, such as STRUCTs. The current exception to this is the ARRAY data type: arrays of arrays are not supported.

How can I select the first value of array with BigQuery Standard SQL?

You can use either OFFSET() or ORDINAL(). The method would be:

select array[offset(0)]


select array[ordinal(1)]


posted on 16 September 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too