2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
I would recommend you switch to the script and edit it to add a few things:
- print out the schema of the dynamic frame of the source. See if that matches your Redshift schema.
- Look for nested fields/structures - you might need a Resolve choice
- use an Apply mapping transform if your schema doesn't match Redshift
- check permissions of the IAM role of your job
répondu il y a 4 mois
0
The data preview won't really insert into Redshift, which is what is really failing, likely a permission issue.
Look in the log for a cause, also looking into the Redshift error table might help (if it got that far): https://docs.aws.amazon.com/redshift/latest/dg/r_STL_LOAD_ERRORS.html
Contenus pertinents
- demandé il y a 7 mois
- demandé il y a 4 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 2 ans
Thank you. Issue was in schema difference between Source and Redshift.