CourseTechnology

Working with JSON, Arrays, and Structs in BigQuery

By External Provider

Price

Free

Go to content

Opens coursera.org in a new tab

Level

BEGINNER

Duration

1 h

About this course

This is a self-paced lab that takes place in the Google Cloud console. 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.

What you will learn

Creating your own arrays with ARRAY_AGG
Querying datasets that already have ARRAYs
Introduction to STRUCTs