Query: redshift_cluster_scheduled_actions

select
  p ->> 'EndTime' as "End Time",
  p ->> 'IamRole' as "IAM Role",
  p ->> 'NextInvocations'  as "Next Invocations",
  p ->> 'Schedule' as "Schedule",
  p ->> 'ScheduledActionDescription' as "Scheduled Action Description",
  p ->> 'ScheduledActionName' as "Scheduled Action Name",
  p ->> 'StartTime' as "Start Time",
  p ->> 'State' as "State",
  p ->> 'TargetAction' as "Target Action"
from
  aws_redshift_cluster,
  jsonb_array_elements(scheduled_actions) as p
where
  arn = $1;