I’m writing a Data Flow in which I make an upsert to a Cosmos DB NoSQL database. My goal is to use a field called batch
to keep track of the date of insertion of a particular document, that is, I want this field to not change over an update. I see that the AlterRow
action doesn’t let me choose which fields to partially upsert or not. Is there a way to accomplish this?
2
Answers
I think if you use UPSERT , then it will update all the fields , but UPDATE should allow you to do so .
Agree with HimanshuSinha-msft if you select
Upsert if
it will update all the columns Instead selectUpdate if
with conditionAnd in sink setting select Update method as
Allow update
and pass partition key.In mapping only select columns you want to update