I was having the same issue, but did not have the region in the URL. I notice your URL has the same issue.

Make sure you have the region in your s3 location like this:

CREATE EXTERNAL DATA SOURCE s3_ds
WITH
(    LOCATION = 's3://some-bucket.s3.us-west-2.amazonaws.com/prefix',
,    CREDENTIAL = s3_dc
)