News for hackers. Stuff that matters.
Re:The fastest tool for querying large JSON files is written... by carlineng on Friday April 15, 2022 @11:40AM (#31041444)
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.
Re:The fastest tool for querying large JSON files is written... by geoduck14 on Friday April 15, 2022 @01:23PM (#31042907)
I'll add to this:

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