BigQuery - UNNEST in SELECT
We can use UNNEST
in the nested fields, rather than unnesting in the WHERE clause and JOIN
SELECT
event_name,
(SELECT value.int_value FROM UNNEST(event_params) WHERE key = "value") as score,
FROM `example_*`
PreviousBigQuery - Split string and get the first partNextBigquery - Sample queries for audiences based
Last updated
Was this helpful?