BigQuery - UNNEST in SELECT
PreviousBigQuery - Split string and get the first partNextBigquery - Sample queries for audiences based
Last updated
Was this helpful?
Last updated
Was this helpful?
Was this helpful?
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_*`