aws-sdk-go is deprecated

[black-dragon74]

aws-go-sdk has been officially deprecated in favor of aws-go-sdk-v2. Original SDK is scheduled to be EOL on 2025-07-31.

This issue is to track the migration in a few places where we still v1 SDK.

Migration Resources: https://aws.github.io/aws-sdk-go-v2/docs/migrating/

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed in a week if no further activity occurs. Thank you for your contributions.