Why doesn't Update Method appear on Sink Settings after adding an alterRow Transformation?

Matthew Boustead 20 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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,797 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 8,551 Reputation points

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful