Snowflake has native stored procedures! How do they differ from the Javascript Stored Procedures and what limitations do we need to keep in mind?


Alongside Arkady Kleyner and Rich Hathaway, we explore the new Snowflake Scripting and compare its functionality to the current JavaScript Stored Procedures.


In this session, you will learn:

  • The difference between Stored Procedures (JS) and Snowflake Scripting
  • Understanding blocks in Snowflake Scripting
  • Working with variables, branching constructs, loops, cursors, and RESULTSETs
  • Returning a value
  • Handling exceptions