Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise