HOW TO: Generate JWT Token for Snowflake Key Pair Authentication?
Learn what JWT token is, how to generate it and pre-requisites to generate it for Snowflake Key Pair Authentication.
Key Pair Authentication in Snowflake
Snowflake supports Key Pair authentication which uses a combination of public-private key pair for enhanced security.
Caller’s and Owner’s Rights in Snowflake Stored Procedures
The stored procedures in Snowflake runs either with caller’s or owner’s rights which defines the privileges with which the procedure executes.
Exceptions in Snowflake Stored Procedures
Snowflake allows catching exceptions and their error information that occur in stored procedures by defining exceptions.
RESULTSET in Snowflake Stored Procedures
Snowflake allows storing the result set of a SELECT statement and return them as output in the form a table using RESULTSET.
Cursors in Snowflake Stored Procedures
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.
Looping in Snowflake Stored Procedures
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
IF ELSE, CASE statements in Snowflake Stored Procedures provides a way to execute a set of statements if a condition is met.
EXECUTE IMMEDIATE in Snowflake Stored Procedures
EXECUTE IMMEDIATE command in Snowflake executes SQL statements present in form a character string and returns the result.
Variables in Snowflake Stored Procedure
A Variable is a named object which holds a value of a specific data type whose value can change during the stored procedure execution.