How to batch items with different partition keys in Cosmos DB ?

Question

Hi,

I want to batch items (update them all in one single operation) in cosmos DB.
The items are in the same container but have different partition keys..
Any idea ?
CreateTransactionalBatch has limitation of using same partitionKey..
any other alternative?

Thanks in advance

Answer 1

Hi @Hala Ibrahim Thanks for posting your question in the Microsoft Q&A forum.

Unfortunately, you cannot perform a bulk update without the Partition Key unless the item was created without a Partition Key.

Regards

Geetha

Answer 2

a cosmos db is made up of partitions. each partition may be on separate server. atomically updating two partitions would require cross server two phase commit, and would break the Comos DB response time commitments.

as a Transaction Batch is an atomic operator by definition, it can not cross partitions. if you don't need an atomic transaction, then

you don't specify your requirements. you could write a cosmos db stored procedure that you passed the batch items to, and it could insert non-atomically.

note: stored process are easier to write, if you create async wrappers for the api calls. see:

https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-write-stored-procedures-triggers-udfs?tabs=javascript