Prerequisites

Before using a Stored Procedure executor, perform the following tasks as needed:
  1. Create a stored procedure that performs a task.

    Do not create a stored procedure that returns tabular data. The Stored Procedure executor does not pass return data to the pipeline.

    You can use any method available with Snowflake to create the stored procedure. For more information, see the Snowflake documentation.

  2. Ensure that you have a role with access to the stored procedure.

    Use the role to define the Role pipeline property. The pipeline uses the specified role to perform Snowflake-related tasks, including executing the stored procedure. For more information, see the Snowflake documentation.