Working with JSON in Snowflake
Get my Modern Data Essentials training (for free) & start building more reliable data architectures
https://www.ModernDataCommunity.com
-----
One of the biggest benefits of Snowflake is its built-in capabilities to work with JSON objects. In this video, we will walk through some of the primary ways you can work with JSON in Snowflake including functions such as PARSE_JSON, GET_PATH and FLATTEN.
Timestamps:
0:00 - Intro
0:13 Query JSON Directly
1:39 Flatten Table Function
3:48 Flatten Multiple Tables
5:01 Parse_JSON Function
6:43 Get_Path Function
7:49 Closing
Title & Tags:
Working with JSON in Snowflake | Snowflake Tutorial
#snowflake #dataengineering #kahandatasolutions
