AWS SDK for go end of support

[rapphil]

According to this https://aws.amazon.com/blogs/developer/announcing-end-of-support-for-aws-sdk-for-go-v1-on-july-31-2025/,
there will be no more releases for AWS SDK for go v1 after July 2025

We should consider migrating to AWS SDK for go v2 so that we reduce the technical dept and prometheus converges to use a single version of this SDK.

There is a similar issue here: prometheus/prometheus#15572

[gen1321]

I assume all the changes will be internal to this package, I think I can migrate it within next week and once all current PRs will be merged

[rapphil]

Hi, yes, they would be all internal to this package. we don't need to leak the detail of what is being used to sign the requests and just make sure that we are keeping the APIs the same.