JSON in Snowflake Masterclass Hands-On

Learn all you need about semi-structured JSON data in Snowflake

Created by: Cristian Scutaru
Snowflake Guru, AWS/Azure/GCP Solutions Architect

What Will I Learn?

• How to load and unload data in JSON format in and from Snowflake
• How to query JSON data from a VARIANT data type
• How to use built-in Snowflake functions for JSON objects and arrays
• How to FLATTEN semi-structured data into tabular data
• How to dynamically extract schema-on-read from JSON data
• How to convert JSON data to other hierarchical formats
• How to call the Snowflake COPY INTO commands for JSON data
• How to design databases using both tabular and hierarchical topologies
• How to create all sorts of simple to complex queries using JSON in Snowflake

Requirements

• Basic SQL query programming skills
• Basic Python programming skills
• Basic beginner-level knowledge of Snowflake, as a data warehouse
• Optional JavaScript programming skills
• Optional knowledge of Streamlit
• No prior knowledge of JSON or other semi-structured data format

Target audience

• Data Engineers collecting semi-structured data in their data pipelines
• Database Administrators learning new design patterns for hybrid tabular-hierarchical data
• Data Analysis who need querying hybrid data stores
• Data Architects willing to learn how to flatten key-value JSON dictionaries and JSON arrays
• SnowPro certification exam candidates, learning about LATERAL FLATTEN in detail
• OLAP and OLTP practitioners, in need to understand how JSON fits into a relational model