turbot/aws_insights

Query: redshift_cluster_scheduled_actions

Usage

powerpipe query aws_insights.query.redshift_cluster_scheduled_actions

Steampipe Tables

SQL

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;

Dashboards

The query is used in the dashboards: