Hey,
When connecting to an S3 bucket specifically in us-east-1, it seems like Cloudberry is using global s3 endpoints (ie s3.amazonaws.com) instead of regional endpoints (ie s3.<region-name>.amazonaws.com). Global endpoints are considered legacy. The AWS UI and newer versions of the AWS SDK have switched to using regional endpoints to interact with buckets (ie put object). Can we start using regional endpoints in Cloudberry.

Links:

https://docs.aws.amazon.com/general/latest/gr/s3.html

- https://docs.aws.amazon.com/AmazonS3/latest/userguide/VirtualHosting.html (Find Global legacy endpoints)