Query: List of SNS topics which are not using Customer Managed Keys(CMK)

Description

Identify instances where Simple Notification Service (SNS) topics are not secured with Customer Managed Keys (CMK). This is useful to ensure all your SNS topics have the added security layer of using your own encryption keys.

Query

Tables used in this query:

• aws_sns_topic

SQL