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
- ¿Cuáles son las ventajas y desventajas de usar Google BigQuery?
- How can I use Google Big Query to count the number of zeros in a given dataset?
- How can I use Google Big Query to integrate with Zephyr?
- How do I use Google Big Query with Zoom?
- How do I set up a Google Big Query zone?
- How can I use Google Big Query to analyze Reddit data?
- How can I use Google BigQuery to answer specific questions?
- How can I learn to use Google BigQuery?
- How can I use Google BigQuery to retrieve data from a specific year?
- How do I use Google Big Query to zip files?
See more codes...