The time has come for Snowflake to start integrating Git!
To celebrate the fact that we’ve gotten git integration , we’re looking into some cool features that come with it :
Creating Stored Procedures based on a .py file in a github repo
Your challenge for this week is to:
– connect to this repo from snowflake : https://github.com/FrostyFridays/FF_week_91
– write a procedure that use the file add_1.py
– create a stored procedure that can use the code from the .py file as a handler to add 1 to a column.
You can use the starting code given below for a small testing table.
Starting Code
CREATE OR REPLACE TABLE people (
id INTEGER,
name VARCHAR
);
INSERT INTO people (id, name) VALUES
(1, 'Alice'),
(2, 'Bob'),
(3, 'Charlie'),
(4, 'David'),
(5, 'Eva'),
(6, 'Fiona'),
(7, 'George'),
(8, 'Hannah'),
(9, 'Ian'),
(10, 'Julia');