Processing nested JSON data from a data lake can be a very laborious transformation task once the data is loaded into your database/data warehouse when done via conventional means, but not with Upsolver. In this interactive demo, we will show you how it just takes a few clicks to flatten nested data in Upsolver and output it to Snowflake for later analytics work. The demo will also illustrate how Upsolver will generate a schema on read for you automatically, inferring names and types and generating statistics for each field to help you with data modeling.

We will also show what is involved in performing the flattening work in Snowflake directly.