Working with Semi-structured Data with Snowflake

Focused View

Warner Chaves

1:37:04

182 View

1. Course Overview

1. Course Overview.mp4

01:14

2. Reading and Writing Semi-structured Data

1. Semi-structured Data.mp4

05:30

2. Loading and Unloading Data.mp4

02:29

3. Demo - Loading JSON.mp4

12:37

4. Demo - Other Load Commands.mp4

10:36

5. Demo - Unloading Data.mp4

04:41

6. Module Summary.mp4

00:46

3. Querying Semi-structured Files

1. Querying Files.mp4

05:32

2. Demo - Querying Files Directly.mp4

13:48

3. Demo - External Tables.mp4

08:37

4. Module Summary.mp4

00:43

4. Working with Semi-structured Fields

1. Semi-structured Fields.mp4

05:00

2. Demo - Objects and Arrays.mp4

15:15

3. Demo - Working with JSON and XML.mp4

09:31

4. Module Summary.mp4

00:45

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Database Programming

Microsoft SQL

Warner Chaves

Instructor's Courses

Warner is a SQL Server Certified Master, MVP, and Solutions Architect at Pythian, a global Canada-based company specializing in data and infrastructure services. A brief stint in .NET programming led to his early DBA formation, working for enterprise customers in Hewlett-Packard's ITO organization. From HP he transitioned to his current position at Pythian, managing multiple clients of different sizes and industries. He leads a highly-talented team of data professionals that keep things running smooth and innovate with all kinds of data solutions. When he's not working out of his office in Ottawa, Ontario, he can be found on the sandy beaches of his home country of Costa Rica.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.