Unnesting JSON Arrays
Each shipment event in logistics.delivery_events carries a stops array inside its JSON payload, recording every location a shipment passed through on its route. To analyze individual legs of a journey, Harbr's data team needs to unnest that array into one row per stop. Your task is to flatten the stops for a multi-leg shipment and identify how many cities it passed through before reaching its destination.
This exercise is part of the course
Data Pipeline Automation in Snowflake
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise