Query: List retention configuration with the retention period less than 1 year

Description

Discover the segments that have a retention period of less than a year in the AWS configuration. This can be useful to identify and review any potentially risky settings where data might not be retained long enough for compliance or auditing purposes.

Query

Tables used in this query:

• aws_config_retention_configuration

SQL