2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
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
답변함 4달 전
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
관련 콘텐츠
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 3년 전
- AWS 공식업데이트됨 일 년 전
Thank you. Issue was in schema difference between Source and Redshift.