Tag: nested

BigQuery query nested json

I have JSON data which is saved in BigQuery as a string. { “event”:{ “action”:”prohibitedSoftwareCheckResult”, “clientTime”:”2017-07-16T12:55:40.828Z”, “clientTimeZone”:”3″, …