Week 5 - Stored Procedures & UDFs

This week, we’re using a feature that, at the time of writing, is pretty hot off the press :
Python in Snowflake.

To start out  create a simple table with a single column with a number, the size and amount are up to you, 

After that we’ll start with a very basic function: multiply those numbers by 3.

The challenge here is not ‘build a very difficult python function’ but to build and use the function in Snowflake.

We can test the code with a simple select statement :

SELECT timesthree(start_int)FROM FF_week_5

Remember if you want to participate:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
2. Post your code to GitHub and make it publicly available (Check out our guide if you don't know how to here)
3. Post the URL in the comments of the challenge.

If you have any technical questions you'd like to pose to the community, you can ask here on our dedicated thread.