- Course
SnowPro Core: Data Transformations
Start your Snowflake journey with the SnowPro Core certification. This course will teach you the data transformation concepts required for the exam.
Intermediate
- Course
SnowPro Core: Data Transformations
Start your Snowflake journey with the SnowPro Core certification. This course will teach you the data transformation concepts required for the exam.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
Data transformation is the foundational skill for delivering reliable analytics and reporting on Snowflake. In this course, SnowPro Core: Data Transformations, you’ll gain the ability to design and implement scalable data transformations on Snowflake.
First, you’ll explore structured data operations, including estimation functions, sampling methods, stored procedures, streams, and tasks.
Next, you’ll discover semi-structured data handling, leveraging the VARIANT column, FLATTEN/LATERAL FLATTEN commands, and specialized semi-structured functions.
Finally, you’ll learn how to process unstructured data using directory tables, SQL file functions, and custom UDFs to extract and analyze free-form text.
When you’re finished with this course, you’ll have the skills and knowledge of Snowflake data transformations needed to succeed on the SnowPro Core Certification exam.
SnowPro Core: Data Transformations
Intermediate
Table of contents
Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.