Azure Synapse SQL - Update

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”))

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description