Microsoft Azure Synapse SQL Connector

Back Next

Rules and guidelines for configuring update override

Consider the following rules and guidelines when you use the update override property for a

Microsoft Azure Synapse SQL

target:

Select

Update

for the

Treat source rows as

property in the advanced target properties.

Specify the update query in the following format:

UPDATE <Target table name> SET <Target table name>.<Column1> = :TU.<Column1>, <Target table name>.<Column2> = :TU.<Column2>, … <Target table name>.<ColumnN> = :TU.<ColumnN> FROM :TU WHERE <Target table name>.<Update Column1> = :TU.<Update Column1> AND <Target table name>.<Update Column2> = :TU.<Update Column2> AND … <Target table name>.<Update ColumnN> = :TU.<Update ColumnN>

Column names for :TU must match the target table column names.

You must specify the update query with a valid SQL syntax because

Microsoft Azure Synapse SQL

Connector replaces :TU with a temporary table name and does not validate the update query.

You cannot change the order of the column mappings using the update override.

You cannot use unconnected fields to the target in the update query.

Microsoft Azure Synapse SQL targets in mappings

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities