google-big-queryHow do I use the UNNEST function in Google BigQuery?
The UNNEST function in Google BigQuery is used to expand an array into a set of rows. It can be used to expand multiple arrays at once.
For example, the following query uses the UNNEST function to expand two arrays, arr1
and arr2
, into two sets of rows:
SELECT *
FROM UNNEST(arr1, arr2)
The output from this query would look like this:
Row arr1 arr2
1 1 a
2 2 b
3 3 c
Code explanation
SELECT *
- Selects all columns from the table.FROM UNNEST(arr1, arr2)
- Uses the UNNEST function to expand the two arrays,arr1
andarr2
, into two sets of rows.arr1
andarr2
- The two arrays to be expanded.
Helpful links
More of Google Big Query
- How do I rename a column in Google BigQuery?
- How can I use Google BigQuery to answer specific questions?
- How do I set up permissions for Google BigQuery?
- How can I use Google Big Query to integrate with Zephyr?
- How can I use Google BigQuery to wait for a query to complete?
- How do I use Google BigQuery Sandbox?
- What are the advantages and disadvantages of using Google BigQuery?
- How do I sign in to Google Big Query?
- How do I use Google BigQuery to understand the meaning of data?
- How can I export data from Google Big Query to an XLSX file?
See more codes...