Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Working with Semi-structured Data with Snowflake

via Pluralsight

Overview

Snowflake offers full support for semi-structured data. This course will teach you how to apply schema on read, loading, and writing to semi-structured file formats, working with the variant data type to interpret semi-structured fields and more.

The Snowflake Cloud Data Platform has full support for semi-structured data stored in formats such as JSON, XML, parquet, and more. In this course, Working with Semi-structured Data with Snowflake, you’ll learn to load, write, and query these data formats that are very common in data engineering projects. First, you’ll explore Snowflake’s supported semi-structured file formats and the powerful and flexible variant data type. Next, you’ll discover how to load and write in popular formats such as JSON, parquet, and more. Finally, you’ll learn how to use Snowflake’s SQL implementation and built-in functions for querying semi-structured data. When you’re finished with this course, you’ll have the skills and knowledge of working with semi-structured data to apply on your next data engineering project.

Syllabus

  • Course Overview 1min
  • Reading and Writing Semi-structured Data 36mins
  • Querying Semi-structured Files 28mins
  • Working with Semi-structured Fields 30mins

Taught by

Warner Chaves

Reviews

4.7 rating at Pluralsight based on 17 ratings

Start your review of Working with Semi-structured Data with Snowflake

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.