Re: Cosmos db spark patch api

Soma · ‎04-05-2023

Hi all we are trying to do cosmos patch api to a array field but the problem I see is we need to collect the data to get the index can you please let us know if we have an alternative as this causes bottleneck on driver

Debayan · ‎04-05-2023

Hi, Could you please clarify on the API as only below API SDKs are available for Azure cosmos DB.

https://learn.microsoft.com/en-us/azure/databricks/external-data/cosmosdb-connector

SQL API
MongoDB API
Cassandra API
Graph (Gremlin) API
Table API

Also, please tag @Debayan with your next response which will notify me. Thank you!

Soma · ‎04-05-2023

We are using SQL api and will try to patch for a array element at a particular index which is also part of the column value so we have to do a collect and get the index of array and set the array index property and then do the patch @Debayan Mukherjee

Debayan · ‎04-09-2023

Hi @somanath Sankaran , Azure Cosmos DB APIs are supported by Microsoft Azure, could you also please engage Azure team on this?

Anonymous · ‎04-07-2023

Hi @somanath Sankaran

Thank you for your question! To assist you better, please take a moment to review the answer and let me know if it best fits your needs.

Please help us select the best solution by clicking on "Select As Best" if it does.

Your feedback will help us ensure that we are providing the best possible service to you. Thank you!

Soma · ‎04-09-2023

No still waiting for response thanks