Stored Procedures

Stored procedures allow you to extend Snowflake SQL by combining it with JavaScript so that you can include standard programming constructs such as branching and looping. Stored procedures also make code easier to maintain and re-use.

Snowflake stored procedures are implemented through JavaScript and, optionally, SQL:

  • JavaScript provides the control structures (branching and looping).

  • SQL is executed within the JavaScript by calling functions in an API. SQL is not required in a stored procedure, but is typically included.

Next Topics: