Deleting all measurements daily

Forum
1

Hello, we are pushing measurements daily to DB, for optimal storage we are thinking of deleting them after this push daily, how would it be possible to do a delete for all those measurements in one API call?

2

You can use this API:

  • Note that depending on the billing metric used, deleted measurements will still count towards billing.
  • Be careful with what you delete, there is no undo functionality. For tests, I would suggest to always include a “source” to restrict any deletions to a single device.
  • if you are using time series mode, dateFrom and dateTo need to be aligned to full hours. This should not be a problem if you want to delete a whole day.
  • Make sure you have the correct understanding of what a day is for you. dateFrom and dateTo will make use of whatever time zone information you provide. Apama normally runs in UTC timezone and “on at” listeners unless you specify a time zone as well.
1 Like
3

You could also have a look if Retention Rules fit your needs: Managing data - Cumulocity documentation