In my other articles, we have talked about how to use basic blocks in Snowflake scripting, how to use Snowflake cursors and Snowflake scripting control structures. In this article, we will check handling error in Snowflake scripting with some relevant examples. Page Contents Introduction Understanding Errors in Snowflake Handling an Exception in Snowflake Scripting Built-in Variables in Snowflake Error Handling Declaring an User-Defined Exception in Snowflake Raising a Declared Exception in Snowflake Basic Snowflake Error Handling Examples Snowflake Anonymous Block with Error Handling Examples Snowflake Stored Procedure with Error Handling…

In another article, we talked about using blocks in Snowflake scripting and Snowflake scripting error handling.. Now, let's learn about something called the Snowflake cursors. We'll see how to use it in stored procedures and anonymous blocks. Page Content Introduction to Snowflake Cursors Understanding Cursor in Snowflake Cursor Syntax and how to use it? Declaring Cursors Opening Cursors Fetching Data from Cursors Closing Cursors Advanced Cursor Techniques Bulk fetching Avoiding large result sets Snowflake Cursor Examples Snowflake Anonymous Block with Cursor Snowflake Stored Procedure with Cursor Returning a Table for…