Query: sns_topic_overview

select
  display_name as "Display Name",
  owner as "Owner",
  kms_master_key_id as "KMS Key ID",
  title as "Title",
  region as "Region",
  account_id as "Account ID",
  topic_arn as "ARN"
from
  aws_sns_topic
where
  topic_arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4);