Call a stored procedure in Azure Synapse SQL

This example Pipeline demonstrates how to call a simple stored procedure.


Stored Procedure Example Pipeline

Download this Pipeline
  1. Configure the Azure Synapse SQL - Stored Procedure Snap to read the employee data from SelectAllEmployee Stored Procedure.

    Stored Procedure Configuration

    On validation, the list of employee details is generated in the second output view:
    Stored Procedure Output

  2. Connect the JSON Formatter Snap to the upstream Stored Procedure Snap to read the output document.
  3. Connect the File Writer Snap to the JSON Formatter Snap to write the employee.json to the SnapLogic database.

    File Writer Configuration

To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.