Writing Stored Procedures

Stored procedures allow you to write procedural code that executes SQL. In a stored procedure, you can use programmatic constructs to perform branching and looping. The topics in this section explain how to write a stored procedure in Snowflake.

Overview of Stored Procedures

Learn about stored procedures, including benefits and difference from UDFs.

Working with Stored Procedures

Create and call stored procedures with SQL and secure them with access privileges.

Understanding Caller’s Rights and Owner’s Rights Stored Procedures

Learn the differences between a caller’s rights stored procedure and an owner’s rights stored procedure.

The following topics describe how you can write stored procedure handlers in various languages.

Writing Stored Procedures in Snowpark (Java)

Write handlers in Java using the Snowpark API.

Writing Stored Procedures in JavaScript

Write handlers in JavaScript using Snowflake’s JavaScript API.

JavaScript Stored Procedures API

Get reference information for Snowflake’s JavaScript API.

Writing Stored Procedures in Snowpark (Python)

Write handlers in Python using the Snowpark API.

Writing Stored Procedures in Snowpark (Scala)

Write handlers in Scala using the Snowpark API.

Writing Stored Procedures in Snowflake Scripting

Write handlers in SQL using Snowflake Scripting.