Query: Name the SNS topics associated with notification rules

Description

Determine which AWS SNS topics the notification rules are targeting. This query uses PostgreSQL's JSON querying capabilities to join on the notification rule targets. Note that due to the cross join, this query will not list notification rules that don't have any targets.

Query

Tables used in this query:

• aws_codestar_notification_rule

SQL