Sometimes your data lands in BigQuery as a nested JSON string. One example might be an a column that has one key for each item — with details about the item nested as shown below.