# How to use snowpark and Snowflake optimization Lecture

> Welcome to Snowflake Day 2! In this lecture, Zach delves into various optimization techniques for Snowflake, including cost optimizations and utilizing Snowpark for data processing. He explains the intricacies of Snowpark, its similarities to Spark, and its role in ETL processes within Snowflake. A…

- Web page: https://www.dataexpert.io/lesson/how-to-use-snowpark-and-snowflake-optimization-lecture-p735-l651
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 7: Analytical Patterns & CDC
- Access: Requires enrollment in AnalyticsExpert
- Length: 48 min video
- Skills: Python, ETL/ELT, Data Warehousing, Cloud Platforms, Snowflake
- Academy: DataExpert.io Academy

## About this lesson

Welcome to Snowflake Day 2! In this lecture, Zach delves into various optimization techniques for Snowflake, including cost optimizations and utilizing Snowpark for data processing. He explains the intricacies of Snowpark, its similarities to Spark, and its role in ETL processes within Snowflake. Additionally, He discusses micropartitioning, lazy execution in Snowpark, and the importance of understanding query patterns for cost management.

## Navigation

- Previous lesson: [Change Data Capture (CDC) and Snowflake basics Lab](https://www.dataexpert.io/lesson/change-data-capture-and-snowflake-basics-lab-p735-l613.md)
- Next lesson: [How to use snowpark and Snowflake optimization Lab](https://www.dataexpert.io/lesson/how-to-use-snowpark-and-snowflake-optimization-lab-p735-l652.md)