Snowflake allows us to write stored procedures in multiple languages such as SQL, JavaScript, and using using the Snowpark API you can also write them in Java, Python and Scala.



In this session I will focus on how to write procedures in SQL and Javascript. Then we will look into how to call them and security aspects.

Also I will show similarities and differences between stored-procs and User Defined Functions.