Query: List of subscriptions which are not configured with dead letter queue

Description

Determine the areas in which AWS SNS Topic subscriptions lack a configured dead letter queue. This is useful for identifying potential points of failure in message delivery, as messages could be lost if the subscription service is unavailable and there is no dead letter queue set up.

Query

Tables used in this query:

• aws_sns_topic_subscription

SQL