2 Risposte
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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
con risposta 4 mesi fa
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
Contenuto pertinente
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
Thank you. Issue was in schema difference between Source and Redshift.