Query: Find user groups with assigned IAM roles

Description

This example identifies all user groups that have IAM roles assigned to them, which helps in reviewing role-based access control configurations.

Query

Tables used in this query:

• aws_cognito_user_group

SQL