turbot/aws_insights

Query: vpc_eips_for_redshift_cluster

Usage

powerpipe query aws_insights.query.vpc_eips_for_redshift_cluster

SQL

select
e.arn as eip_arn
from
aws_redshift_cluster as c,
aws_vpc_eip as e
where
c.elastic_ip_status is not null
and e.public_ip = (c.elastic_ip_status ->> 'ElasticIp') :: inet
and c.arn = $1;