This Snap has exactly one document input view.

The input document is used to build the update query. Below is an example of how an input document is translated to a query.

Input document:

{
    "Color": "blue",
    "ListPrice": 7.22
}

Query:

update "Database"."Table"
set [ListPrice] = 7.22,
    [Color] = 'blue'

• Mapper

This Snap has at most one output view and produces documents in the view.

The output fields of a single view are:

• message - the summary of the query outcome
• status - for successful queries the number of rows updated and for failed queries the error code
• original - the input document

• Mapper

Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the pipeline.

Default value: Azure SQL - Update

Default value: N/A

Example: SalesData

Default value: N/A

Sample Update SQL query:

UPDATE table_name SET column1 = value1, column2 = value2,
WHERE condition;

{
  "valueToUpdate" : "true",
  "original": {
    "col1" : "KEY"
   }
}

Examples without using expressions:

• EmpId = 12
• email = '[email protected]'

Examples using expressions:

• "EMPNO=$EMPNO and ENAME=$EMPNAME"
• email = $email
• emp=$emp
• "emp='" + $emp + "'"
• "EMPNO=" + $EMPNO + " and ENAME='" + $EMPNAME+ "'"

Default value: N/A

Example: EmpId = 12