Working with JSON data in BigQuery
Walking through how to handle data written as JSON to your BigQuery tables.
In short, you'll want to use the JSON_EXTRACT function to extract the path that you're looking to split out as a separate column.
Want to dive into our free Google BigQuery course? Pick it up at:
https://learn.codingisforlosers.com/l...