2 Answers
- Newest
- Most votes
- Most comments
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
answered 4 months ago
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
Relevant content
- asked 2 months ago
- asked 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
Thank you. Issue was in schema difference between Source and Redshift.