Added dynamic region listing for partitions using AWS SDK V2; applied to aws_acm_*, aws_sns_*, aws_sqs_*, aws_cloudtrail_* and aws_guardduty_* tables.

Added dynamic region listing for partitions using AWS SDK V2; applied to aws_acm_*, aws_sns_*, aws_sqs_*, aws_cloudtrail_* and aws_guardduty_* tables. #5561