turbot/aws_insights

Query: kms_key_input

Usage

powerpipe query aws_insights.query.kms_key_input

Steampipe Tables

SQL

select
coalesce(a.title, k.title) as label,
k.arn as value,
json_build_object(
'target_key_id', a.target_key_id,
'account_id', k.account_id,
'region', k.region
) as tags
from
aws_kms_key as k
left join aws_kms_alias as a
on a.target_key_id = k.id
order by
a.title;