Query: backup_recovery_point_min_retention_35_days

select
  recovery_point_arn as resource,
  case
    when (lifecycle -> 'DeleteAfterDays') is null then 'ok'
    when (lifecycle -> 'DeleteAfterDays')::int >= 35 then 'ok'
    else 'alarm'
  end as status,
  case
    when (lifecycle -> 'DeleteAfterDays') is null then split_part(recovery_point_arn, ':', -1) || ' retention period set to never expire.'
    else split_part(recovery_point_arn, ':', -1) || ' recovery point has a retention period of ' || (lifecycle -> 'DeleteAfterDays')::int || ' days.'
  end as reason
  , region, account_id
from
  aws_backup_recovery_point;