How to Get Started with Snowpark for Python on Snowflake

In today's episode we're getting started with Snowpark for Python on our Snowflake database. Snowpark can give you some amazing functionality that will add power to your Python arsenal when using Snowflake. We're going to overcome one big gotcha in the installation process, get it installed using pip, then we're going to do some python to select data from our warehouse to make sure our Snowpark installation is working correctly.
Let's go!

Related Videos:
How to Get Started with Snowpark for Python on Snowflake
You are watching this one now!
How to Use Snowpark Dataframes in Python
How to Run Python User Defined Functions in Snowpark
How to Create Python Stored Procedures in Snowpark

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#snowflake #snowpark #python

[harikrishnanm]

sir, can you please make an on video to write data from different databases to Snowpark

Could i use this for apps with high traffic ? To replace a mysql or Postgres db ?

[cardionadine]

The hook on your wall worries me a little.

[eshanm]

How to resolve : AttributeError: module 'snowflake.snowpark.session' has no attribute 'builder'

[djabakavadze]

Hello, I'am stuck while trying to connect. Can someone help me with this error :

OperationalError Traceback (most recent call last)
File ~\AppData\Local\miniconda3_python3.8\lib\site-packages\snowflake\connector\connection.py:1064, in SnowflakeConnection.__authenticate(self, auth_instance)
1063 try:
-> 1064 auth.authenticate(
1065 auth_instance=auth_instance,
1066 account=self.account,
1067 user=self.user,
1068 database=self.database,
1069 schema=self.schema,
1070 warehouse=self.warehouse,
1071 role=self.role,
1072 passcode=self._passcode,
1073 passcode_in_password=self._passcode_in_password,
1074 mfa_callback=self._mfa_callback,
1075 password_callback=self._password_callback,
1076 session_parameters=self._session_parameters,
1077 )
1078 except OperationalError: