3 ms·
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.
by carlineng 4y ago
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.
- geoduck14 4y agoI'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