Edited
Slightly modified from https://www.pascallandau.com/bigquery-snippets/expression-subqueries-for-nested-repeated-fields/.
Changes: UNION JOBS_BY_PROJECT and JOBS_BY_USER
BigQuery: Use expression subqueries for querying nested and repeated fields | pascallandau.com
Using expression subqueries to query nested nd repeated fields in Google BigQuery
4
4
0