# Advanced Snowflake: Data Modeling and UDFs Lecture

> Advanced Snowflake data modeling and user-defined functions (UDFs) are explored in this technical lecture, ideal for data engineers looking to deepen their understanding of Snowflake's capabilities. Key topics include the comparison of Snowflake with Iceberg, complex data types such as arrays, maps…

- Web page: https://www.dataexpert.io/lesson/advanced-snowflake-data-modeling-and-udfs-lecture-p735-l563
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 4: Advanced Snowflake
- Access: Requires enrollment in AnalyticsExpert
- Length: 42 min video
- Skills: SQL, Data Modeling, APIs, Snowflake
- Academy: DataExpert.io Academy

## About this lesson

Advanced Snowflake data modeling and user-defined functions (UDFs) are explored in this technical lecture, ideal for data engineers looking to deepen their understanding of Snowflake's capabilities. Key topics include the comparison of Snowflake with Iceberg, complex data types such as arrays, maps, and variants, and the nuances of UDFs, UDAFs, and UDTFs. Participants will learn about effective data modeling strategies, the compression hierarchy, and how to implement external API calls within Snowflake, enhancing their data engineering skill set.

## Navigation

- Previous lesson: [Advanced snowflake: Deploying the Capstone dag Lab](https://www.dataexpert.io/lesson/advanced-snowflake-deploying-the-capstone-dag-lab-p735-l562.md)
- Next lesson: [Advanced Snowflake: Data Modeling and UDFs Lab](https://www.dataexpert.io/lesson/advanced-snowflake-data-modeling-and-udfs-lab-p735-l564.md)