- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
That connection very likely needs a VPC, when you use it in a visual job it gets automatically added to the job (in the Job Details tab) and your script job doesn't have that.
So where and how can I add the VPC , subnet and SG group info in above script?
I found that option in Job details. I see the PostgreSQL connection part is working fine. I am still getting connection timeout error for snowflake. I am using snowflake connection type in destination. I have SF credentials in AWS secret manager. Do I need to change anything in script for Snowflake part. I already added the VPC info for snowflake connection and postgresql connection in job details.
An error occurred while calling o101.pyWriteDynamicFrame. JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to qha38537-etlworks-us-prod.snowflakecomputing.com:443 [qha38537-etlworks-us-prod.snowflakecomputing.com/52.27.88.193, qha38537-etlworks-us-prod.snowflakecomputing.com/44.241.78.214, qha38537-etlworks-us-prod.snowflakecomputing.com/34.215.202.59] failed: connect timed out.
Contenuto pertinente
- AWS UFFICIALEAggiornata 3 anni fa
- Come posso risolvere gli errori di connessione di Marketplace AWS nei miei processi ETL in AWS Glue?AWS UFFICIALEAggiornata 7 mesi fa
notice I said you have to add it in the Job Details tab, not the script