Working with JSON, Arrays, and Structs in BigQuery | | GSP416
In this lab you will work in-depth with semi-structured data (ingesting JSON, Array data types) inside of BigQuery. Denormalizing your schema into a single table with nested and repeated fields can yield performance improvements, but the SQL syntax for working with array data can be tricky. You will practice loading, querying, troubleshooting, and unnesting various semi-structured datasets.
Quest :- https://google.qwiklabs.com/quests/68
Lab :- https://google.qwiklabs.com/focuses/3...
Program's Syllabus :- https://events.withgoogle.com/googlec...
#googlecloudreadyfacilitatorprogram #googlecloudtraining #googlecloudready