Snowflake - Build & Architect Data pipelines using AWS

Overview

Course Update as of Feb 2023 :

This Course has been updated with Snowpark APIwhich covers UDFs,Stored Procedures for ETLand also covers Machine Learning use-case deployments . This course will help you clear SnowPro Advanced Certifications

Syllabus

• Introduction to Snowflake and AWS
Overview of Cloud Data Warehousing
Introduction to Snowflake Architecture
Basics of AWS Services for Data Pipelines
• Setting Up Snowflake on AWS
Creating and Configuring Snowflake Accounts
IAM Roles and Permissions in AWS for Snowflake
• Data Loading and Unloading in Snowflake
Efficient Data Loading Techniques
Using COPY Command and External Tables
Best Practices for Data Unloading
• Building Data Pipelines
Designing Efficient Data Pipelines
Automation with Snowpipe
Integrating AWS Lambda for Orchestration
• Snowpark API and UDFs
Introduction to Snowpark API in Python/Java
Developing User-Defined Functions (UDFs)
Testing and Deploying UDFs
• Stored Procedures for ETL
Writing and Debugging Stored Procedures
Using Stored Procedures for Complex ETL
Scheduling and Automating Stored Procedures
• Machine Learning Use-Cases with Snowflake
Introduction to Machine Learning in Snowflake
Data Preparation for Machine Learning
Model Deployment and Integration with Data Pipelines
• Advanced Optimization Techniques
Query Performance Tuning in Snowflake
Using Materialized Views
Scaling and Resource Optimization in AWS
• Preparing for SnowPro Advanced Certifications
Exam Overview and Preparation Strategies
Key Topics and Study Resources
• Course Wrap-Up
Summary and Review of Key Concepts
Final Project: Designing a Comprehensive Data Pipeline
Q&A and Open Discussion

---

Taught by

Sid Raghunath

---

Subjects

Business