Reply To: Understanding SQL Server parsing of GA4 BigQuery RECORD columns

[Oliver]

In BigQuery, you can use functions like UNNEST to handle arrays of STRUCTs and extract their individual elements. However, if you’d prefer to convert the STRUCTs data into JSON format, BigQuery also allows this by using the TO_JSON_STRING function. Then, you can easily parse and analyze your data using BigQuery’s built-in JSON functions.