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
已提問 9 個月前檢視次數 1007 次
1 個回答
0
已接受的答案

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 pictureAWS
專家
已審閱 9 個月前
  • 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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南