Access denied when trying to import RDS exported snapshots

0

Hey,

I am setting up a pipeline to run import Aurora exported Snapshots. But I do get an error messages when running this copy command:

COPY tableA
FROM 's3://my-export-bucket/export-2020-12-10-1m8hbn/service/app.tableA/'
IAM_ROLE 'arn:aws:iam::xxxxxxx:role/RedshiftRole'
FORMAT AS PARQUET;

I get:

[2020-12-17 15:21:32] [XX000][500310]
[2020-12-17 15:21:32] [Amazon](500310) Invalid operation: Spectrum Scan Error
[2020-12-17 15:21:32] Details:
[2020-12-17 15:21:32] -----------------------------------------------
[2020-12-17 15:21:32] error: Spectrum Scan Error
[2020-12-17 15:21:32] code: 15001
[2020-12-17 15:21:32] context: Error: HTTP response error code: 403 Message: AccessDenied Access Denied
[2020-12-17 15:21:32] x-amz-request-id: A6C1550481534373
[2020-12-17 15:21:32] x-amz-id-2: aouS/sKqNsXECBWdKVMwJMU1w90EBSPM2xVL8fy2fe4xmaSkchUP94kZiim3ZQHrovMGfVmZwlY=
[2020-12-17 15:21:32] query: 30427038
[2020-12-17 15:21:32] location: dory_util.cpp:945
[2020-12-17 15:21:32] process: fetchtask_thread [pid=13477]
[2020-12-17 15:21:32] -----------------------------------------------;

My Bucket Policy is in place:

{
"Sid": "BucketPolicyForSpectrum",
"Effect": "Allow",
"Principal": {
"AWS": "arn:aws:iam::xxxxx:root"
},
"Action": [
"s3:GetObject",
"s3:List*"
],
"Resource": "arn:aws:s3:::my-export-bucket/*",
"Condition": {
"StringEquals": {
"aws:UserAgent": "AWS Redshift/Spectrum"
}
}
}

Any ideas how to debug this?

已提问 3 年前314 查看次数
2 回答
0

OK seems my server side bucket was encrypted. Put it into a non encrypted bucket seems to work. At least one step ahead

已回答 3 年前
0

See my last comment. Having a server side encrypted storage probably needs more permissions :)

已回答 3 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则