Working with JSON, Arrays, and Structs in BigQuery

In this lab you will work with semi-structured data (ingesting JSON, Array data types) inside of BigQuery. You will practice loading, querying, troubleshooting, and unnesting various semi-structured datasets.

• GSP416
• Overview
• Setup
• Task 1. Create a new dataset to store the tables
• Task 2. Practice working with arrays in SQL
• Task 3. Creating your own arrays with ARRAY_AGG()
• Task 4. Querying datasets that already have arrays
• Task 5. Introduction to STRUCTs
• Task 6. Practice with STRUCTs and arrays
• Task 7. Lab question: STRUCT()
• Task 8. Lab question: Unpacking arrays with UNNEST( )
• Task 9. Filtering within array values
• Congratulations!