Unable to add AWS redshift data source

[vinay_athiyil]

I tried to add a data source using Amazon Redshift, It failed got following error message:

Sorry, we encountered an error and were unable to complete your request.

Error ID: 59e3ea2f

I tried without SSL option.

In my VPC, I have added 142.251.74.0/23  with 5439 port for allowing  connections

[sweidenk · Accepted solution]

It looks like Looker Studio is unable to connect to your Redshift host, which could indicate an issue with your VPC settings. Can you verify that the hostname is reachable? The Looker Studio documentation recommends using Whois for this, and the Redshift documentation recommends using SQL Workbench/J to verify the connection.

[vinay_athiyil]

Thanks for the update. Is it possible to connect using ssh tunneling
through a bastion host?


Thanks,
Vinay

[sam8]

I'd recommend testing your Redshift connectivity with other tools!

https://docs.aws.amazon.com/dms/latest/sbs/chap-rdsoracle2redshift.steps.connectredshift.html

[vinay_athiyil]

Thanks for help. I can figure out the issue by changing AWS subnet and security group settings

[maxjeison]

How? I am with same problem! I already test with DBeaver locally and run correctly, but with LookerStudio not.