Snowpark for Python | Snowflake Tutorial

What is Snowpark and how can you use it when coding in Python? Snowpark is an API on top of Snowflake that enables developers to transform data, design models, and create data-centric applications using programming languages such as Scala, Java and Python.  

In this video we break down how to create data frames, the concept of lazy execution and how to utilize methods such as .save(), .collect(), and .join().  

By the end of the video you will have a solid foundation on how to use Snowpark to query and process data in Python.  

Whether you are a expert data engineer, or just beginning to learn about data, Snowpark programming is an incredible skill to have. 

00:00 Introduction
00:59 What is Snowpark?
02:16 Creating Sessions
04:25 Data Frames & Lazy Execution
07:05 .show() v.s. .collect()
09:07 Basic Transformations
16:14 .join()
20:24 Functions
27:23 Conclusion

#snowflake #snowpark #python

[kiranpatil]

This is one of the best snowpark video I have found among YouTube. So easy to understand and point to point.

[ronnitroyburman]

This is one of the best Snowpark tutorials out there! Thanks @Aimpoint Digital!! Will be tuned in for future videos.

[agermoune]

Wow! Very simple to understand and love the combination of coding and theory explanation. Chris, you got the gift to convey a complete message in an easy one. Please don't stop as there a not a lot of clear snowpark videos on YouTube. One thing I was hoping to see is the initial setup and connection to snowflake also importing snowflake connection. Liked, subscribed immediately, and even pushed the bell so I won't miss any future videos

[AlessandroBertolino-jz]

doesn't recognize my config module

from config import *
ModuleNotFoundError: No module named 'config'

what should i do? thanks in advance

[JohnLanze-hzql]

Quantity was applied to just the discount which is how this ended up with the negative revenues. Quantity should have been applied to the whole equation. Enjoyed the video though. Good walkthrough

[br]

Amazing content, thanks for sharing. I have a few doubts
1. What are the pros & cons of Snowpark vs SageMaker
2. If we want to redo SageMaker codes with Snowpark are there limitations?
3. Are there data type challenges of using Snowpark?
4. Quickest way to ramp up on Snowpark?

[abinashbehera]

how do we cast date to string or string to date in snowpark?

[shubhamgoyal]

Hey, great introductory video, can you advice how I can access a nested column while selecting them from a table?

[sushanto]

I have a SQL problem which I want to solve.

Able to achieve half the way but another part is pending, pls help in this.

Thank you for so beautiful simple explanation

[dipeshg]

So snowpark code is just like databricks pySpark code :D . Thanks It's clear now that Snowpark and Databricks are for spark processing.

[AZIARGROUS]

Very nice. So basically, snowpark is "async" by design in a way.

[varuntyagi]

Great Video!! Can you please create a video on how to design the Session Configs section so that it can connect to Snowflake that has Single Sign On and also how to move this code in QA and production environments ( CI/CD)? you can also create a Udemy course for that I will buy that :)

[SonLeTyP]

snowpark is good imo, the only things I dont like it much is snowpark only supports only python 3.8.