Azure data factory Cosmos Db delete record

Question

hello

After run an ETl process through ADF I need to run a bluk delete on cosmos DB . I know that ADf doesn't suppor this feature but it could be possible to do it through an azure function.
I don't know how to deal with a bulk delete(based on a condiition) do you ahve examples athat guides me how to do it?

many thanks

Answer 1

@Diana Milena Coronado Granados

Our Azure Cosmos DB product owner @Mark Brown - MSFT has replied to you on StackOverflow thread.

Here is answer:
"Currently there is no way to do a bulk delete or truncate on a Cosmos container. Typically the way most people do this today is to delete and then recreate the container. That avoids the RU/s cost of deleting every item."

Please let us know if you need any further help regarding this.

Thanks
Navtej S