How to perform bulk updates with CosmosDB Core API similar to UPDATE command in SQL?

John Glista 0 Reputation points
2023-09-05T13:47:25.58+00:00

We have a CosmosDB Core API instance and are finding it difficult to perform one-off bulk updates of our data, similar to how you use the UPDATE .... SET X = Y command with a relational SQL database. The initial research I performed pointed me in the direction of using Core API over the others because we are not migrating from MongoDB, do not need a graph DB, and wanted all the latest features that the platform has to offer. However, I'm now wishing we would have gone with the MongoDB API as it looks to be very easy to use a Mongo "scratch pad" for executing these types of updates.

Is it only possible to perform these types of one-off bulk updates by creating a stored procedure inside the Azure Data Explorer? This seems extremely inconvenient for simple data updates, and if that is true, I'm surprised Microsoft hasn't released an easier way to do this. Is there an archive of examples somewhere to at least make using stored procedures easier?

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,439 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Mark Brown - MSFT 2,761 Reputation points Microsoft Employee
    2023-09-18T22:19:11.91+00:00

    @John Glista Unfortunately there are not a lot of 3rd party tools created for NoSQL API. SQL has been around for 50+ years so has had time to build a healthy ecosystem of tooling.

    The only thing I can think of in your situation is there is this one that does mention the ability to update multiple documents at once. https://alpaqastudio.com/features. Hope that helps.

    0 comments No comments