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?

gefragt vor 3 Jahren314 Aufrufe
2 Antworten
0

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

beantwortet vor 3 Jahren
0

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

beantwortet vor 3 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen