BigQuery - Transpose JSON data stored in repeated string field type to a table

How to Transpose0:01:35

How to Transpose JSON Data in Google BigQuery for Efficient Data Analysis

Materialized Column: An0:21:34

Materialized Column: An Efficient Way to Optimize Queries on Nested Columns