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.
Este ejercicio forma parte del curso
Snowflake Architecture
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
Empezar ejercicio