The sink in your dataflow must support upserts, updates, or deletes. Not all sink types in Azure Synapse Analytics support these operations. For instance, update methods are not applicable if you're writing to a file-based sink like Azure Data Lake or Azure Blob Storage.
Why doesn't Update Method appear on Sink Settings after adding an alterRow Transformation?
Matthew Boustead
40
Reputation points
After adding alterRow transformation and inputting the delete row expressions successfully in my dataflow area, I can see the rows that are supposed to be deleted on the Data preview page but as I go onto Sink Data there is no option in the Sink Settings to 'Update Method' - an option I have noticed pops up for others when they get to this stage.
Any help would be greatly appreciated.