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.
[ Parent
| on HN ]
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