Create a stored procedure

Create a stored procedure

Use Snowflake: its Snowflake Procedure API lets you create a stored procedure in a single step (POST /api/v2/databases/{database}/schemas/{schema}/procedures). capabilities.work can help you get signed up and connected.

• How do I create a stored procedure with its arguments, return type and language?
• Can a new procedure run with the caller's rights instead of the owner's?
• Is it possible to mark a procedure as secure when I create it?

Say it to your AI assistant

• Create procedure {name} in {database}.{schema} taking {arguments}, returning {return_type}, written in {language}.
• Create procedure {name} ({arguments}) returning {return_type} in {language} with body {body}.
• Create procedure {name} with args {arguments}, return {return_type}, language {language}, executing as {execute_as}.

For your developer

POST /api/v2/databases/{database}/schemas/{schema}/procedures in Snowflake Procedure API. Full spec on APIs.io.