Defining Arguments

Snowflake stored procedures can include required and optional arguments. All arguments defined in the selected Snowflake stored procedure appear as properties in the resulting Stored Procedure executor. All values defined for argument properties must be constants. Arguments cannot return tabular data.

Argument properties are listed in the same order that the arguments are listed in the Snowflake stored procedure.

Tip: To ensure that you define the argument properties appropriately, consult the Snowflake stored procedure signature or definition. Argument properties are not named in the executor at this time.

For example, the following drop_columns Snowflake stored procedure includes the review and rating arguments:

CREATE OR REPLACE PROCEDURE RATING_CHECK(review VARCHAR, rating VARCHAR)
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS OWNER
AS
BEGIN
  ...
END;

To configure this Stored Procedure executor correctly, you treat the first set of argument properties in the executor like the review argument, and the second set like the rating argument, as follows: