Basic Use Case (Azure SQL - Update)

This example demonstrates how to use the Azure SQL - Update Snap to update records in an Azure SQL table using an input document from an upstream Snap. The input document fields map directly to the table columns being updated.

Download this Pipeline
  1. Configure an upstream Snap (for example, a JSON Generator) to provide input documents. Each document's fields correspond to the columns to be updated in the target table.

    For example, an input document { "Color": "blue", "ListPrice": 7.22 } generates the update query: UPDATE "Database"."Table" SET [ListPrice] = 7.22, [Color] = 'blue'

  2. Configure the Azure SQL - Update Snap: set Schema Name and Table Name to identify the target table.
  3. Set the Update Condition to define the SQL WHERE clause. For example: EmpId = 12 or email = '[email protected]'
    CAUTION: Avoid string concatenation in update conditions to prevent SQL injection risks. Always enclose string values in single quotes — for example, use Name = 'username', not Name = username.
  4. Execute the pipeline. The Snap outputs one summary document per update, containing a message (outcome summary), status (row count or error code), and original (the input document).
To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.