Query: backup_plan_rules

select
  r ->> 'RuleId' as "Rule ID",
  r ->> 'RuleName' as "Rule Name",
  r -> 'Lifecycle' as "Lifecycle",
  r -> 'CopyActions' as "Copy Actions",
  r -> 'RecoveryPointTags' as "Recovery Point Tags",
  r -> 'ScheduleExpression' as "Schedule Expression",
  r -> 'StartWindowMinutes' as "Start Window Minutes",
  r -> 'EnableContinuousBackup' as "EnableContinuousBackup",
  r -> 'CompletionWindowMinutes' as "Completion Window Minutes"
from
  aws_backup_plan,
  jsonb_array_elements(backup_plan -> 'Rules') as r
where
  account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)
  and arn = $1;