Snowflake - Working with semi-structured JSON data in Snowflake

3900 E Mexico Ave

3900 E Mexico Ave · Denver, Co

How to find us

Park behind the building in the parking garage. Go to Suite 1000

Location image of event venue


In Snowflake, it is best practice to load and store semi-structured data--JSON, XML, Avro, etc.--into a column with a data type of VARIANT vs. parsing the semi-structured string into structured columns on source data load. I'll start with cover the basics of how Snowflake handles semi-structured data, using JSON as a specific example. Then cover more complex schema structures like arrays and nested arrays within the JSON document and aggregation and filtering against the contents of a VARIANT.

Snowflake Users Group[masked]
Thu, Jan 10,[masked]:45 PM - 7:45 PM MST

Please join my meeting from your computer, tablet or smartphone.

This meeting is locked with a password: STUVM

You can also dial in using your phone.
(For supported devices, tap a one-touch number below to join instantly.)

United States (Toll Free):[masked]
- One-touch: [masked],,[masked]

United States: +1 (646)[masked]
- One-touch: [masked],,[masked]

Access Code:[masked]

First GoToMeeting? Let's do a quick system check: