Stored Procedure Executor

The Stored Procedure executor triggers a Snowflake stored procedure after receiving at least one row of data. The executor can trigger any Snowflake stored procedure that performs a task and does not return tabular data. The executor does not pass return values to the pipeline.

Use the Stored Procedure executor to perform a task after it receives data. For example, you might use a Stored Procedure executor to truncate a source table after data is written to pipeline destinations.

Note: Unlike other executors, the Stored Procedure executor does not display on the Executor tab of the Stage Selector dialog box. Instead, to add a Stored Procedure executor to a pipeline, use the Functions tab to select the Snowflake stored procedure that you want to use.

Selecting a stored procedure in the Stage Selector dialog box creates a Stored Procedure executor that is customized based on the selected procedure. The executor displays the name and signature of the stored procedure and provides properties that correspond to the arguments defined in the stored procedure.

When you configure the Stored Procedure executor, you define the values for arguments. All values must be constants.