Query: kms_key_state

select
  'State' as label,
  key_state as value,
  case when key_state = 'Enabled' then 'ok' else 'alert' end as "type"
from
  aws_kms_key
where
  arn = $1
  and region = split_part($1, ':', 4)
  and account_id = split_part($1, ':', 5);