Working with JSON, Arrays, and Structs in BigQuery
Offered By: Google via Google Cloud Skills Boost
Course Description
Overview
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.
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!
Tags
Related Courses
MongoDB for DBAsMongoDB University MongoDB for Node.js Developers
MongoDB University Web Engineering II: Developing Mobile HTML5 Apps
Technische Hochschule Mittelhessen via iversity Programming Mobile Services for Android Handheld Systems: Communication
Vanderbilt University via Coursera HTML, CSS, and Javascript for Web Developers
Johns Hopkins University via Coursera