Connect to Snowflake using python connector
Posted on by Sumit Kumar
In this blog, we will learn how to connect to snowflake using python connector.
Follow below step:-
1)Create a trial account on snowflake using below URL.
you will get 30 days free trial and $300 of credit to explore various features of the snowflake.
2)Login to trial account, create virtual warehouse select size as x-small, Auto suspends time as 5 mnt and Auto resume as yes to save your free credit.
3)By using Snowflake UI , Create database, schema, and table then load data into the created table.
we will query from the same table using python.
4)Install Python/Python IDE.
I am using Pycharm.
Go to File-> setting->Project Interpreter and install snowflake-connector-python.
5)Create a python file and use the below code to connect and query from the snowflake.
Leave a Reply