ADF Cosmos DB Sink - upsert with multiple keys

Question

ADF Cosmos DB Sink - upsert with multiple keys

Tom 1

I'm using Cosmos DB Sink in ADF and I need possibility to update/upsert items by multiple key fields.
Such feature is available in Synapse Analytics Sink already.
Do you plan to add that feature for Cosmos DB sink or is there any alternative?

AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-05-18T15:32:47.597+00:00

Hi @Tom ,
Welcome to Microsoft Q&A platform and thanks for posting your query here.
As I understand your query, you want to know if we can add multiple columns in the key columns option while performing upsert for CosmosDB sink or not.
Please help me understand if 'upsert_key_column' is the parameter inside your dataflow which contains the list of column names with comma seperated value or a single column . Also, there is an add option at the right side of the text box, Isn't it giving the option to add multiple columns for you?

Please let me know the above details in order for us to provide better help. Thanks in advance!
Tom 1 Reputation point

2022-05-18T20:02:50.277+00:00

Hi,.
Add multiple columns option is enough to achieve what I need.

Thanks
AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-05-19T10:26:36.9+00:00

Hi @Tom ,
I tried to reproduce your scenario by creating cosmosDB dataset and treating it as sink , trying to perform upsert. There is no option to select keyColumns , please confirm that the screenshot you provided is using CosmosDB sink or Synapse DB as sink?
Tom 1 Reputation point

2022-05-19T14:12:42.81+00:00

Hi @AnnuKumari-MSFT ,

The screenshot I've provided does show Synapse DB sink. Do you plan to add this feature to CosmosDB sink?

Thanks

1 answer

Your answer

AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-05-18T15:32:47.597+00:00

Hi @Tom ,
Welcome to Microsoft Q&A platform and thanks for posting your query here.
As I understand your query, you want to know if we can add multiple columns in the key columns option while performing upsert for CosmosDB sink or not.
Please help me understand if 'upsert_key_column' is the parameter inside your dataflow which contains the list of column names with comma seperated value or a single column . Also, there is an add option at the right side of the text box, Isn't it giving the option to add multiple columns for you?

Please let me know the above details in order for us to provide better help. Thanks in advance!
Tom 1 Reputation point

2022-05-18T20:02:50.277+00:00

Hi,.
Add multiple columns option is enough to achieve what I need.

Thanks
AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-05-19T10:26:36.9+00:00

Hi @Tom ,
I tried to reproduce your scenario by creating cosmosDB dataset and treating it as sink , trying to perform upsert. There is no option to select keyColumns , please confirm that the screenshot you provided is using CosmosDB sink or Synapse DB as sink?
Tom 1 Reputation point

2022-05-19T14:12:42.81+00:00

Hi @AnnuKumari-MSFT ,

The screenshot I've provided does show Synapse DB sink. Do you plan to add this feature to CosmosDB sink?

Thanks

Answer 1

AnnuKumari-MSFT 34,566 Microsoft Employee Moderator

Hi @Tom ,
Thanks for your query.

Unfortunately, this feature is not yet available for CosmosDB sink.

Appreciate if you could share the feedback on our Azure data factory feedback channel, which would be open for the user community to upvote & comment on. This allows our product team to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-05-21T10:36:05.523+00:00

Hi @Tom ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-08-03T05:07:58.58+00:00

Hi @Tom ,

To perform update or delete or Upsert, We won't see Key column selection. It will be default to "id" key.

Kindly check this thread: https://learn.microsoft.com/en-us/answers/questions/936171/index.html

-----------

Please do consider clicking Accept Answer as accepted answers help community as well.

Share via

ADF Cosmos DB Sink - upsert with multiple keys

1 answer

Your answer