Using Power Automate I want to connect with Amazon Redshift but can't establish connection.
I am getting below error.
ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "prd-planit-dw-05-redshift-cluster.cukzxuiolrur.eu-west-1.redshift.amazonaws.com" (10.209.22.253) and accepting TCP/IP connections on port 5439? inner exception: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "prd-planit-dw-05-redshift-cluster.cukzxuiolrur.eu-west-1.redshift.amazonaws.com" (10.209.22.253) and accepting TCP/IP connections on port 5439? clientRequestId: 55e3d9ca-1fc0-45f4-8106-971ed19cd682
Hello!
I have the same issue as you mentioned @Anonymous. Any update?
Regards
With the ip address being a 10.* address, it looks like you need to make sure you're using an On-Premises Gateway. My problem is that the screen to add the connection doesn't allow me to select a gateway!
Edit: If I create a new Dataflow, I can select Redshift as the data source, then in the next config screen I can select a gateway. I don't need to save the dataflow, the connection is created regardless.
Hi, I'm getting the same error. Trying to connect to redshift serverless. Did you find a way past this?
Michael E. Gernaey
6
Super User 2025 Season 1
KT-07051015-0
4
GI-06050833-0
2