BigQuery - UNNEST in SELECT
We can use UNNEST in the nested fields, rather than unnesting in the WHERE clause and JOIN
SELECTevent_name,(SELECT value.int_value FROM UNNEST(event_params) WHERE key = "value") as score,FROM `example_*`
We can use UNNEST in the nested fields, rather than unnesting in the WHERE clause and JOIN
SELECTevent_name,(SELECT value.int_value FROM UNNEST(event_params) WHERE key = "value") as score,FROM `example_*`
