Snowflake’s handling of JSON data via the “variant” data type is quite nice to work with, both in terms of speed and convenience of the access methods.
The variant column is useful for "let's dump this data into this column and separate it out in the nextstep"
Snowflake comes with a couple of methods of parsing semi structured data like JSON, XML, and even "custom" formats
We are playing around with Snowflake at work right now and I quite like it