turbot/aws_insights

Query: rds_db_snapshots_for_kms_key

Usage

powerpipe query aws_insights.query.rds_db_snapshots_for_kms_key

Steampipe Tables

SQL

select
arn as db_snapshot_arn
from
aws_rds_db_snapshot as s
where
s.kms_key_id = $1
and s.region = split_part($1, ':', 4)
and s.account_id = split_part($1, ':', 5);