Unnesting RECORD arrays in BigQuery SQL
Using the CROSS JOIN UNNEST() function to flatten arrays into single rows in BigQuery, using the Google Analytics sample BigQuery dataset.
Learn more and grab the SQL cheat sheet at https://codingisforlosers.com/learn-b....