Enable Partition Key delete feature for Cosmos account

Question

Enable Partition Key delete feature for Cosmos account

Pavan Kumar Jannaikode 20 Microsoft Employee

Hi,

I need to use the API DeleteAllItemsByPartitionKeyStreamAsync (https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-delete-by-partition-key?tabs=dotnet-example) for one of my usecase. I enabled the DeleteAllItemsByPartitionKey capability by following the document and setting it up in a lower environment. I have following doubts, can someone please help me with them questions:

Should I be adding this capability manually on all the accounts that I want this capability?
Can this be handled through an automated ARM templates?
Will reaching out to Support with the list of the accounts help so the support can add it in bulk?

Thanks,
Pawan

Manasa Akula 680 Reputation points Microsoft External Staff Moderator

2025-04-21T01:05:25.82+00:00

Hi Pavan Kumar Jannaikode,

Greetings!

As we understand that, you need to use DeleteAllItemsByPartitionKeyStreamAsync API capability. Here are the answers to your queries:

1.Manual Addition of Capability: Yes, currently the DeleteAllItemsByPartitionKey capability must be explicitly enabled for each Cosmos DB account where you plan to use this API. It is not enabled by default, so manual configuration is necessary unless automated through deployment tooling.

2.Automation via ARM Templates: As of now, this capability is not yet configurable via ARM templates or other infrastructure-as-code tools like Bicep or Terraform. The capability must be enabled through the Azure Portal.

3.Reaching Out to Support for Bulk Enablement: Yes, please refer the doc for Use a stored procedure like the one provided in this sample to bulk delete documents based on a partition key value https://github.com/Azure/azure-cosmosdb-js-server/blob/master/samples/stored-procedures/bulkDelete.js

I hope this information helps. Please do let us know if you have any further queries.

If the comment is helpful, please click "Upvote it".
Manasa Akula 680 Reputation points Microsoft External Staff Moderator

2025-04-22T00:42:44.7733333+00:00

Hi Pavan Kumar Jannaikode

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Manasa Akula 680 Reputation points Microsoft External Staff Moderator

2025-04-23T00:39:59.54+00:00

Hi Pavan Kumar Jannaikode

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Accepted answer

1 additional answer

Your answer

Manasa Akula 680 Reputation points Microsoft External Staff Moderator

2025-04-21T01:05:25.82+00:00

Hi Pavan Kumar Jannaikode,

Greetings!

As we understand that, you need to use DeleteAllItemsByPartitionKeyStreamAsync API capability. Here are the answers to your queries:

1.Manual Addition of Capability: Yes, currently the DeleteAllItemsByPartitionKey capability must be explicitly enabled for each Cosmos DB account where you plan to use this API. It is not enabled by default, so manual configuration is necessary unless automated through deployment tooling.

2.Automation via ARM Templates: As of now, this capability is not yet configurable via ARM templates or other infrastructure-as-code tools like Bicep or Terraform. The capability must be enabled through the Azure Portal.

3.Reaching Out to Support for Bulk Enablement: Yes, please refer the doc for Use a stored procedure like the one provided in this sample to bulk delete documents based on a partition key value https://github.com/Azure/azure-cosmosdb-js-server/blob/master/samples/stored-procedures/bulkDelete.js

I hope this information helps. Please do let us know if you have any further queries.

If the comment is helpful, please click "Upvote it".
Manasa Akula 680 Reputation points Microsoft External Staff Moderator

2025-04-22T00:42:44.7733333+00:00

Hi Pavan Kumar Jannaikode

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Manasa Akula 680 Reputation points Microsoft External Staff Moderator

2025-04-23T00:39:59.54+00:00

Hi Pavan Kumar Jannaikode

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Vahid Ghafarpour 23,385 Volunteer Moderator

https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-delete-by-partition-key?tabs=dotnet-example

Unfortunately, The feature is not enabled by default, so you must configure it for each account separately.

For sure, you can enable the capability using Azure Resource Manager (ARM) templates or Azure CLI.

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

Answer 2

Pavan Kumar Jannaikode 20 Microsoft Employee

Thank you @Manasa Akula and @Vahid Ghafarpour for your prompt responses. I actually followed the CLI approach to enable it manually. Also good to know that this feature is not yet supported through ARM templates.

Share via

Enable Partition Key delete feature for Cosmos account

1 additional answer

Your answer