Query: sns_topic_encryption_table

select
  t.title as "Topic",
  case
    when kms_master_key_id is not null then 'Enabled'
    else null
  end as "Encryption",
  t.kms_master_key_id as "KMS Key ID",
  a.title as "Account",
  t.account_id as "Account ID",
  t.region as "Region",
  t.topic_arn as "ARN"
from
  aws_sns_topic as t,
  aws_account as a
where
  t.account_id = a.account_id
order by
  t.title;