YoVDO

Working with JSON, Arrays, and Structs in BigQuery

Offered By: Google via Google Cloud Skills Boost

Tags

BigQuery Courses SQL Courses Data Warehousing Courses JSON Courses Struct Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

SAP Business Warehouse powered by SAP HANA
SAP Learning Relational Database Support for Data Warehouses
University of Colorado System via Coursera Data Warehouse Concepts, Design, and Data Integration
University of Colorado System via Coursera Business Intelligence Concepts, Tools, and Applications
University of Colorado System via Coursera Design and Build a Data Warehouse for Business Intelligence Implementation
University of Colorado System via Coursera