Create a Stored Procedure
Create a new stored procedure within a database schema
POST
POST /v1/storedProcedures
Create a Stored Procedure
Create a new stored procedure within a database schema.Body Parameters
Fully qualified name of the parent DatabaseSchema, for example
snowflake_prod.analytics.public.POST /v1/storedProcedures
Returns
Returns the created stored procedure object with all specified properties and system-generated fields.Response
Create or Update (PUT)
UsePUT /v1/storedProcedures instead of POST to perform an upsert. If a stored procedure with the same fullyQualifiedName already exists, it will be updated; otherwise, a new stored procedure is created. The request body is the same as POST.
PUT will not return a 409 conflict error if the entity already exists — it will update the existing entity instead. However, for certain fields (such as description, tags, owners, and custom properties), PUT preserves an already-populated value instead of overwriting it with an empty or omitted one — the exact behavior depends on the field and the calling user or bot’s permissions, not a blanket rule. See Entity Update Behavior for the full preserve/merge rules. Use PATCH to intentionally replace an existing value.Bulk Create or Update (PUT)
UsePUT /v1/storedProcedures/bulk to create or update multiple stored procedures in a single request. The request body is an array of create request objects.