AWS Glue Cross Account Not working

0

Running into a time out issue on below scenario

Trying to establish Glue connection from Account B (where my Glue crawler and catalog is) to Account A (Ec2 SQL Server) . Requirement is to pull all the data and write it back to Account B (Aurora PostgreSQL). I am able to do telnet connection, JDBC connection (using SQL CMD) by launching an EC2 bation host in same VPC,SUBNET,SECURITY GROUP of Glue job (Account B) to account A and can query sql server with no issues but when I do the same through GLUE Connection , I am getting timeout error. No restrictions on NACL,FW etc. Question : 1.Glue under the hood, creates ENI and establishes connection. In all the Glue documentation , I see references for "VPC Peering" for cross accounts and no where Transist Gateway is mentioned. In my customer environment Transist Gateway is being used. I doubt if this will be even an issue. just want to rule that out , if anybody has any idea, pls let me know. 2.What else could be wrong , when JDBC is working ?

1 Risposta
0

Hello,

This article explains how to configure AWS Glue to connect to another VPC. Ignore the NAT private gateway part, as it is needed only in the case of overlapping IP addresses, but the basics of connecting to other VPCs using AWS transit gateway remain the same.

https://aws.amazon.com/blogs/big-data/scale-aws-glue-jobs-by-optimizing-ip-address-consumption-and-expanding-network-capacity-using-a-private-nat-gateway/

profile picture
con risposta 5 giorni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande