SnowPro Core: Data Transformation
As part of this course, the learner will explore and understand how to do data transformation leveraging the Snowflake tool on structured, semi-structured, and unstructured data.
What you'll learn
Snowflake is a cloud database which is leveraged by multiple Fortune 500 companies for transforming data. In this course, SnowPro Core: Data Transformation, you will learn how to do data transformation leveraging the Snowflake database. First, you will explore how to analyze structured data using the Snowflake database, and functions such as sampling techniques and estimating functions to analyze the structured data. Next, you will discover how to explore semi-structured data using Snowflake, and understand the multiple file formats which could be loaded to Snowflake. Finally, you will learn how to investigate unstructured data in Snowflake by understanding directory tables, UDF, and more. When you are finished with this course, you will have the skills and knowledge of how to do data transformation leveraging the Snowflake database.
Table of contents
- Understanding Structured Data 5m
- Create Snowflake Developer Account 3m
- Approximate Query Processing: Estimate Functions 4m
- Demo: Estimating Similarity of Two Datasets 4m
- Demo: Estimating Frequent Values 3m
- Demo: Estimating Percentile Values 2m
- Sampling Function 2m
- Demo: Sampling 4m
- UDF and Stored Procedures 2m
- Mind Map 3m
About the author
Ranjan Relan is a Founder/CTO of GenAI company - AgentAnalytics.com . He previously worked as AI, Data and Tech Strategy Consultant with more than 16+ years of experience in the field of Analytics which includes working on Machine Learning, Big data and Data ware housing projects. He has helped clients across Hi Tech, Telecom and Pharma domain in developing data strategy, cloud adoption strategy, analytics strategy ,solution architecture.