turbot/aws_insights

Query: redshift_snapshots_for_redshift_cluster

Usage

powerpipe query aws_insights.query.redshift_snapshots_for_redshift_cluster

SQL

select
s.akas :: text as snapshot_arn
from
aws_redshift_snapshot as s,
aws_redshift_cluster as c
where
s.cluster_identifier = c.cluster_identifier
and s.region = c.region
and s.account_id = c.account_id
and c.arn = $1;