SnowflakeStage区域错误(签名不匹配)

Question

Iam在通过AWS S3复制到snowflake时收到此错误。

copy into ORDER1 from 's3://path' credentials = (aws_secret_key '<secret_key' aws_key_id = '<key_id>');

据我所知，我的凭据值是正确的，而且我的S3路径也是正确的，我可以知道如何纠正以下错误吗？

Failure using stage area. Cause: [The request signature we calculated does not match the signature you provided. Check your key and signing method. (Status Code: 403; Error Code: SignatureDoesNotMatch)]

Answer 1

在我看来，您的复制到语句中有一个拼写错误，您不是在aws_secret密钥旁边缺少'='吗？

文档中的语法https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html是

credentials=(aws_key_id='$AWS_ACCESS_KEY_ID' aws_secret_key='$AWS_SECRET_ACCESS_KEY')