Query: Check for notification rules with no targets

Description

Determine which notification rules lack targets. This query uses PostgreSQL's JSON querying capabilities to count the number of targets configured.

Query

Tables used in this query:

• aws_codestar_notification_rule

SQL