Query: elasticache_cluster_node_notification_configuration

select
  t.title as "Topic Title",
  notification_configuration ->> 'TopicStatus' as "Topic Status"
from
  aws_elasticache_cluster as c
  left join
    aws_sns_topic as t
    on notification_configuration ->> 'TopicArn' = topic_arn
where
  c.arn = $1
  and c.account_id = split_part($1, ':', 5)
  and c.region = split_part($1, ':', 4);