Apply retention period for pending escalation tables
Context
The tables incident_management_pending_alert_escalations
& incident_management_pending_issue_escalations
are both partitioned with a monthly strategy, to hedge bets on future performance. (context on partitioning decision - !62361 (comment 593978330), !64274 (merged))
The records are expected to span ~2 tables, covering 1 month of data. "Past" tables are expected to be empty, so we want remove these tables to keep queries for these models performant.
Proposal
Retention periods for partitioning tables are WIP:
Once these features have been successfully rolled out, a retention period should be added for both incident_management_pending_X_escalations
tables.
EX) Add retain_for: <X>.months
to BasePendingEscalation
, like in WebHookLog