turbot/aws_thrifty

Query: redshift_cluster_max_age

Usage

steampipe query aws_thrifty.query.redshift_cluster_max_age

Plugins & Tables

SQL

select
arn as resource,
case
when date_part('day', now() - cluster_create_time) > $1 then 'alarm'
when date_part('day', now() - cluster_create_time) > $2 then 'info'
else 'ok'
end as status,
title || ' created on ' || cluster_create_time || ' (' || date_part('day', now() - cluster_create_time) || ' days).'
as reason,
region,
account_id
from
aws_redshift_cluster;

Controls

The query is being used by the following controls: