With the increasing prevalence of semi-structured data from IoT devices, web logs, and other sources, data architects and modellers have to learn how to interpret and project data from things like JSON.

While the concept of loading data without upfront modelling is appealing to many, ultimately, in order to make sense of the data and use it to drive business value, we have to turn that schema-on-read data into a real schema! That means data modelling!

In this webinar, we will walk through both simple and complex JSON documents, decompose them, then turn them into representative data models. We will then show you how they might look using both traditional 3NF and data vault styles of modelling. In this session you will:

  • See what a JSON document looks like
  • Understand how to read it
  • Learn how to convert it to a standard data model
  • Kent Graziano

    Chief Technical Evangelist, Snowflake