Querying Snowy Peak's avalanche event data
Snowy Peak's avalanche sensors output data in JSON format: each event contains a location, risk level, timestamp, and sensor metadata nested inside the record.
A stage called AVALANCHE_STAGE and a JSON file called avalanche_events.json have already been set up for you. Your job is to load the data into a VARIANT table and query it.
This exercise is part of the course
Snowflake Architecture
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise