Best way to clean up azure storage table

Question

Hi

We need suggestion on clearing the azure storage table on basis of dates bi-weekly including blobs. I believe we still can use retention policy for storage blobs but that will not be applicable for Azure table scenario. for this cleaning activity we want to keep it cheaper as much as possible and it should be able to run inside the vnet with user managed Identity.

Thanks
Manish

Answer 1

Hi @Anonymous Thank you for posting your question on Microsoft Q&A.

You would need to write a custom solution to clean up your resources. You can do it with PowerShell, or with one of the Azure SDKs

Regards,
Oury

Answer 2

I was also in same situation and finally achieved it with a powershell script.

Answer 3

if you need to cleanup whole table it is possible (and faster especially if table contains a lot of items) to delete this table and recreate it again with the same name