1. Learn
  2. /
  3. Courses
  4. /
  5. Introduction to BigQuery

Connected

Exercise

UNNEST-ing Data

It is more than likely that you will work with nested data such as ARRAYs and STRUCTs. Accessing the data inside those queries will help you create a lot of value from that data and use it to connect to other tables.

Instructions 1/3

undefined XP
    1
    2
    3
  • Complete the query to explore one row of data with the order_items column for the order_id is 'a0e747c954a595b0e3458c87ab1a4958'.