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

Matthew Boustead 40 Reputation points
2023-11-14T10:40:50.6966667+00:00

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.
5,003 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 26,491 Reputation points
    2023-11-14T15:16:31.2333333+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.