# Advance Snowflake Day 2 Lab

> In this lab, Zach dives into chunking, RAG, and parsing, focusing on processing documents with Cortex. He reviews how to efficiently parse filings and transcripts, emphasizing the importance of filtering out short, unhelpful chunks. He also discusses the need to optimize their queries and explore i…

- Web page: https://www.dataexpert.io/lesson/advancesnowflakeday2-jan2026-p735-l1912
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 4: Advanced Snowflake
- Access: Requires enrollment in AnalyticsExpert
- Length: 50 min video
- Skills: SQL, NLP, Data Modeling, ETL/ELT, Snowflake
- Academy: DataExpert.io Academy

## About this lesson

In this lab, Zach dives into chunking, RAG, and parsing, focusing on processing documents with Cortex. He reviews how to efficiently parse filings and transcripts, emphasizing the importance of filtering out short, unhelpful chunks. He also discusses the need to optimize their queries and explore indexing options for faster results.

## Navigation

- Previous lesson: [Advance Snowflake Day 2 Lecture](https://www.dataexpert.io/lesson/advancesnowflake%20day2lecture-jan2025-p735-l1911.md)
- Next lesson: [Apache Iceberg: Big Data History Lecture](https://www.dataexpert.io/lesson/apache-iceberg-lecture-day-1-apr2025-1-p735-l1192.md)