Week 91 – DevOps & CI/CD

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.

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');