When you configure an update override, the Secure Agent uses the query that you specify, stages the data in files, and then loads that data into a temporary table using the merge command. The data from the temporary table is then loaded to the Databricks target table. The syntax that you specify for the update query must be supported by Databricks Delta:

Specify the update override query in the following format:

MERGE INTO <Target table name> AS A USING :TU AS B ON A.<Column1> = B.<Column1> WHEN MATCHED THEN UPDATE SET A.<Column2> = B.<Column2>, A.<Column3>= B.<Column3> ... A.<ColumnN>= B.<ColumnN>

where,

:TU

represents the incoming data source for the target transformation. The Secure Agent replaces

:TU

with a temporary table name while running the mapping and does not validate the update query.