Source
Querying Semi-structured Data
This topic explains how to use special operators and functions to query complex hierarchical data stored in a VARIANT.
How to: Query Semi-Structured Data in Snowflake
ISSUE: This article details how to query semi - structured data in Snowflake. It also details accessing individual fields, type - casting and use of FLATTEN function.