Simple play icon Course
Skills Expanded

Analyze Semi-structured Data in Snowflake

by Warner Chaves

This course introduces Snowflake’s capabilities for working with semi-structured data. These are critical for performing data analysis tasks when working with popular semi-structured formats like JSON.

What you'll learn

The Snowflake Cloud Data Platform has native capabilities for analyzing semi-structured data.

In this course, Analyze Semi-structured Data in Snowflake, you’ll learn about the platform’s features that help you analyze semi-structured data formats like JSON and parquet.

First, you’ll explore the semi-structured data formats supported by Snowflake.

Next, you’ll discover the different options for loading this data into tables.

Finally, you’ll go through multiple examples of system functions and query styles you can use to extract the information you need from semi-structured data columns.

When you’re finished with this course, you’ll have the skills and knowledge of Snowflake's features needed to analyze semi-structured data.

About the author

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 ... more

Ready to upskill? Get started