Hi All,
I am getting below error while trying to connect to redshift using IN Database tool.
Error: Connect In-DB (27): Error SQLDriverConnect: [Amazon][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 "xx-xx-xxxx.xxxxxxxx.xx-xxx-x.redshift.amazonaws.com" (xx.xx.xx.xx) and accepting TCP/IP connections on port 5439?
I have updated the redshift driver (AmazonRedshiftODBC64-1.3.1.1000) but no help. whereas on SquirrelSQL, I am able to connect smoothly.
PS. Facing this issue post update.
Hi @VJ_dup_337 - this error is coming straight from Redshift; this post covers some of the reasons why you may be experiencing it and some possible solutions
Can we get any help from Alteryx to solve this issue?
You can email in to support@alteryx.com and we will be happy to assist
Use the Simba Amazon Redshift Driver downloaded from the Alteryx licenses & downloads driver section.
Tried Simba Amazon Redshift 1.4.62.1001 64-bit same issue any other feasible sollutions
Can you try limiting your query (like top 10)? Everything I'm seeing online seems to say that it relates to resource allocation on the server or network failure (maybe your VPN is dropping because of the size of the data)? so can you check if a quick query with a top 10 limit works? and are you using input data or in-db?
If you are using input data and it's a large data source - you should be using In-DB.