1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
0
Hi There
Upsert is available for Redshift targets not MySQL
You will need to have custom logic to do other operations besides Inserts. Check out this article for one way of doing updates on MySQL using pymysql. https://awstip.com/aws-etl-glue-job-insert-update-support-7a396db832b
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- Come posso risolvere gli errori di connessione di Marketplace AWS nei miei processi ETL in AWS Glue?AWS UFFICIALEAggiornata 3 mesi fa
- AWS UFFICIALEAggiornata 3 anni fa
I tried the solution proposed in the article. However, it looks like the job is timing out on below line - connection = glue_client.get_connection(Name="<My Connection>")
I do not see any exception in the logs.
The same connection worked when I used it in another job for insert-only, created from Visual editor. Also, test connection works fine.