Extracting JSON key value pairs in BigQuery
Short Intro to JSON in BigQuery
Bigquery introduced the ablity to deal with JSON structures a while ago. It supports both string values that represent JSON structures as well as a native JSON data type. You…