Query: List unencrypted SNS topics associated with each event subscription

Description

Explore which event subscriptions are associated with unencrypted SNS topics. This can help identify potential security risks in your AWS Redshift environment.

Query

Tables used in this query:

• aws_redshift_event_subscription

SQL