CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Introduction to BigQuery

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Complete the below query

SELECT
	-- Add the correct column name
	order_id, ___
FROM 
	ecommerce.ecomm_orders
-- Complete the where statement
WHERE ___ = ___
Modifier et exécuter le code