Snowflake allows catching exceptions and their error information that occur in stored procedures by defining exceptions.

Snowflake allows storing the result set of a SELECT statement and return them as output in the form a table using RESULTSET.

Cursors allows you to loop through a set of rows of a query result set and perform same set of defined actions for each row individually.

Loops in Snowflake Stored Procedures enables you to execute a set of statements until a particular condition is satisfied.

IF ELSE, CASE statements in Snowflake Stored Procedures provides a way to execute a set of statements if a condition is met.

EXECUTE IMMEDIATE command in Snowflake executes SQL statements present in form a character string and returns the result.