Azure Synapse SQL - Update
- Kalpana Malladi
- Gouri Bhagchandani
- Amritesh Singh
- Sandhya Sriram
In this article
Overview
You can use this Snap to update existing records in the target tables with the specified conditions. Document keys are used as the column update, and their values are used as the updated column value.
The updates are batched until the account's Batch size field, or the structure of the update statement changes. An update statement changes if an incoming document contains different keys than a previous document.
Snap Type
The Azure Synapse SQL Update Snap is a WRITE-type Snap that executes an SQL update.
Prerequisites
A valid database account with the required permissions.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
Known Issues
None.
Behavior Changes
The jOOQ upgrade for the Azure Synapse SQL Snap Pack from v3.9.1 to v3.17.x resulted in the following behavior:
Previously, when “null”(string) was passed from the upstream Mapper Snap for the Bigint datatype, the Azure Synapse SQL Update Snap updated it as null without displaying any error. It displayed the status as 0 and the output message as Success. Now, the Snap displays the following error in this scenario:Error converting value (expecting a number but you are sending String(“null”))