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.