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.
Bu egzersiz
Introduction to BigQuery
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Complete the below query
SELECT
-- Add the correct column name
order_id, ___
FROM
ecommerce.ecomm_orders
-- Complete the where statement
WHERE ___ = ___