Cosmos db spark patch api

[Soma]

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]

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]

We are using SQL api and will try to patch for a array element at a particular index which is also part of the col​umn 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]

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

[Anonymous]

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]

No still waiting for response thanks ​