Semi structured data and Snowflake

Semi structured data has become another pillar of many data related deliveries. It provides more flexibility compared to structured data. Such flexibility is very often needed by many workloads, especially those ones which are built around various APIs, IoT sensors or web apps. JSON has become de facto „standard“ for communication between APIs. Not being structured as traditional relational data brings another challenges how to process and work with such data structures. In following blog posts I would like to go through Snowflake capabilities related to processing semi structured data. Let’s cover the whole data lifecycle, starting with ingestion, through processing up to serving the data to consumers.

What is semi structured data?

This article was originally written for SELECT. You can find complete blog post here.