Unnest non-array JSON in BigQuery
I have data arriving as separate events in JSON form resembling: { "id":1234, "data":{ "packet1":{"name":"packet1", "value":1}, "packet2":{"name":"packet2", "value":2} } } I'd like to unnest the data to essentially have one row per 'packet' (there may be any number of packets).…