CODEWITHSUNDEEP
python-3.xamazon-web-servicesaws-glueamazon-vpcpygresql
user3502355
user3502355

Reputation: 177

AWS Glue Python Shell script timing out

I am trying to connect to and read an on-premise data source using an AWS Glue Python Shell job. I am using Pygresql (which comes bundled on Glue) and Pandas. Everything works locally.

But when I push this job up to Glue, the database connections all timeout. Why is this happening? Do I need to do something magic with VPCs?

Upvotes: 0

Views: 445

Answers (2)

Sandeep Fatangare
Sandeep Fatangare

Reputation: 2144

Note that pygresql SQL query doesn't work in python shell. Recommended is postgresql

Upvotes: 0

pdanchenko
pdanchenko

Reputation: 212

I guess you need to create a Glue connection with your VPC settings and attach it to the Glue job.

Upvotes: 1

Related Questions