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.
Overview
Syllabus
- 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!