Snowflake SQL: Making Schema-on-Read a Reality (Part 2)
This is the 2nd of my articles on the Snowflake blog.
In the first article of this series, I discussed the Snowflake data type VARIANT, showed a simple example of how to load a VARIANT column in a table with a JSON document, and then how easy it is to query data directly from that data type. In this post I will show you how to access an array of data within the JSON document and how we handle nested arrays. Then finally I will give you an example of doing an aggregation using data in the JSON structure and how simple it is to filter your query results by referring to values within an array.
Check out the rest of the post here:
The Data Warrior