ERROR doing import from AWS

General
#1

Hi,

I’m trying to import a csv file from AWS but it’s returning me this error al the time: failed to create s3 reader: 403: "The request signature we calculated does not match the signature you provided. Check your key and signing method.

anyone had this problem too?

(I checked several times my AWS keys, tried diferent ones, the files exists, etc)

#2

Hi @morci7,

One gotcha with specifying AWS credentials as query parameters is that they often contain non-URL-safe characters that need to be URL-encoded. In Go, you could use url.QueryEscape; in JavaScript, you could use encodeURIComponent.

Could you give that a try and report back?

#3

You are right! Just encoding the keys where enough to make it work. Maybe it should be explained at documentation.

Thank you!

#4

Thanks for the report @morci7. @jesse Could we include this in documentation?

#5

Sorry for the delay. I created an issue to add this detail to the docs: https://github.com/cockroachdb/docs/issues/2238.