Python | How to Setup Snowpark Environment in Local Machine

Python | How to Setup Snowpark Environment in Local Machine

Setting up a Snowpark environment on your local machine allows you to leverage the power of Snowflake for data processing and analytics. Whether you’re a data engineer, data scientist, or data analyst, having a local Snowpark environment can significantly enhance your productivity and facilitate experimentation. In this post, we’ll walk you through the steps to set up a Snowpark environment on your local machine.

Step 1) Create your free/paid account on snowflake by filling the required details like first name, last name, company email, company name, role and country. (in place of company email you can give your personal email too)

snowflake sign up page
snowflake sign up page

Step 2) Download Anaconda Distribution from Anaconda Website.

anaconda website
anaconda website

Step 3) Open anaconda terminal and run the below given commands:

  • conda create --name py38_snowpark --override-channels -c https://repo.anaconda.com/pkgs/snowflake python=3.8 numpy pandas 
  • conda virtual env
    conda virtual env
  • conda activate py38_snowpark
  • conda install snowflake-snowpark-python
  • conda install snowpark
    conda install snowpark
  • Open python terminal by typing python and then hit enter. 
  • python 3_8 terminal
    python 3.8 terminal

Step 4) Run below code to test the connectivity from snowflake:

from snowflake.snowpark import Session

connection_parameters = {
'account': '###############',
'warehouse': 'COMPUTE_WH',
'database': '#######',
'schema' : '########',
'user': '##############',
'password': '######',
'role' : 'ACCOUNTADMIN'
}

# Create a Snowpark session
session = Session.builder.configs(connection_parameters).create()

tmstamp = session.sql("select current_timestamp").collect()
print(tmstamp)
snowpark sample code
snowpark sample code

Note:
1) Ensure you have Python 3.8 or a later version installed.
2) On snowflake website, you will get connection parameters required information from the admin section.

snowflake portal
snowflake portal

By following the steps mentioned in this post, you can quickly get started with Snowpark and begin building data applications with ease. So, roll up your sleeves and start exploring the capabilities of Snowpark in your local environment!

Leave a Reply

Your email address will not be published. Required fields are marked *

📢 Need further clarification or have any questions? Let's connect!

Connect 1:1 With Me: Schedule Call


If you have any doubts or would like to discuss anything related to this blog, feel free to reach out to me. I'm here to help! You can schedule a call by clicking on the above given link.
I'm looking forward to hearing from you and assisting you with any inquiries you may have. Your understanding and engagement are important to me!

This will close in 20 seconds