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:
- 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)
- Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
- 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.