Semi-structured Data: Loading and Querying JSON & XML Data in Snowflake

Snowflake 2022    |    Intermediate
  • 11 Videos | 1h 19m 32s
  • Includes Assessment
  • Earns a Badge
Structured data follows a fixed schema, usually does not contain hierarchical information, and is typically stored in a tabular format. Alternatively, semi-structured data does not adhere to a fixed schema, supports hierarchical information, and offers schema flexibility and standardization. The Snowflake platform offers support for structured and semi-structured data. In this course, learn how to load JSON and XML data in Snowflake tables and examine Snowflake's OBJECT, ARRAY, and VARIANT types. Next, explore data validation, how you can handle source data errors in a load process, and how to query JSON structures in Snowflake. Finally, practice loading and querying XML data, including using Snowflake functions. Upon completion, you'll be able to work with JSON and XML data in Snowflake.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    recall how structured and semi-structured data work
    set up a table and internal Snowflake stage and load JSON data into the stage
    access unstructured JSON data from Snowflake
    load JSON data as arrays into Snowflake tables
    extract column values from JSON data and load them into a regular Snowflake table
  • perform load operations with various configurations and file patterns
    remove unnamed outer arrays from JSON data when loading into Snowflake
    execute queries on JSON data containing nested structures
    query XML data and flatten out hierarchical data
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 5s
    UP NEXT
  • Playable
    2. 
    Structured, Unstructured, and Semi-structured Data
    6m 42s
  • Locked
    3. 
    Setting Up a Table and Stage for JSON Data
    9m 34s
  • Locked
    4. 
    Accessing Unstructured JSON Data from Snowflake
    8m 30s
  • Locked
    5. 
    Loading Arrays into Snowflake Tables
    4m 33s
  • Locked
    6. 
    Extracting Column Values to a Relational Table
    4m 57s
  • Locked
    7. 
    Performing Load Operations for JSON Data
    12m 17s
  • Locked
    8. 
    Stripping Away Outer Arrays from JSON
    5m 33s
  • Locked
    9. 
    Querying JSON Data and Flattening Nested Data
    11m 53s
  • Locked
    10. 
    Querying XML Data and Flattening Hierarchical Data
    11m 7s
  • Locked
    11. 
    Course Summary
    2m 24s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.