Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise