why can't I connect to my Redshift serverless database?

0

I've been trying for a few hours to connect to my Redshift serverless database - I'm following steps on this page:
https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html I'm trying to connect from DBeaver (jdbc) that I just downloaded two days ago with the latest drivers. The connection just times-out. Using DBeaver I am able to connect to my MySQL RDS database with no issues. For Redshift I did have to create a new VPC with 3 subnets as that is what Redshift requires. I've assigned a security group with the Redshift and Inbound IPv4 traffic on the Inbound Rule. I've also enabled the Turn on Publicly Accessible option on the serverless security page. Default namespace, default workgroup used - I copy the Endpoint from the workgroup page into DBeaver connection, when I Test Connection the jdbc format looks correct.
Just keeps timing out.

billb
질문됨 10달 전1035회 조회
1개 답변
1
수락된 답변

Hello.
Are routes destined to Internet Gateway added to the route table for the subnet on which Redshift Serverless is running?
https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html#serverless-publicly-accessible

profile picture
전문가
답변함 10달 전
profile picture
전문가
검토됨 하루 전
profile pictureAWS
전문가
검토됨 10달 전
  • Riku thank you - I went thru every step again following the link you provided. I am finally able to connect, not sure if it was the Allow Public Access setting or something else, but I was able to trace thru from the VPC to the subnets, route table and gateway and got it all working.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인