The School of Data: Working with JSON, Arrays, and Structs in BigQuery

GDG Cloud Twin Cities
Wed, Oct 26, 6:00 PM (CDT)

31 RSVP'ed

About this event

A data warehouse isn't complete without some data, so this week we're learning about using semi-structured data BigQuery, and connecting data from other databases using Data Catalog Connectors.  This week we're continuing to learn Data Warehousing in BigQuery, hands-on.


This week's hands-on labs:

Working with JSON, Arrays, and Structs in BigQuery

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.

Build and Execute MySQL, PostgreSQL, and SQLServer to Data Catalog Connectors

In this lab you will explore existing datasets with Data Catalog and mine the table and column metadata for insights.


You'll work through Google Cloud labs to get hands-on experience and when you complete each whole quest, you earn a badge for your LinkedIn!


We're learning and sharing Google Cloud skills weekly hands-on events using Qwiklabs to help you learn more about Cloud Computing and running your projects on Google servers in the cloud.


Invite a friend who could benefit, and we'll be happy to help them also get access to qwiklabs.com and to help them get started

Don't miss out on the fun on Wednesdays as we learn cloud computing skills, one week at a time, with a goal of helping you level up!

All upcoming events:

https://gdg.community.dev/gdg-cloud-twin-cities/#upcoming-events

Speaker


Host

  • Jeff Williams

    Jeff Williams

    UC Berkeley

    Google Tech Lead

    See Bio

Organizers