Frustration with SQL connections when using Amazon Redshift
Hi,
Many posts and issues have been opened about this problem but I am still waiting for a reasonable solution to the issue.
When I connect to a db on redshift I get disconnected quite frequently. This by itself is not a big issue the real issue arises that everytime it reconnects it tries to synchronize and therefore to instrospect the schemas. This take at least 1 minute given that I have multiple large tables with large number of columns as well as multiple schemas.
SOLUTION 1. Do not loose connection.
In my mind the best solution would be to not get disconnected in the first place. I tried changing my advanced setting to:

But this didn't work.
SOLUTION 2: AUTO-CONNECT
A second best solution may be to auto-connect - this is currently a "feature" request whereas in my mind the fact that it doesn't automatically reconnect is more of a bug than a feature.
HACK SOLUTION 3: Turn-off instrospect schemas when reconnecting
A third solution that would at least solve my biggest frustration (waiting time everytime i reconnect of > 1 min) would be to not automatically instrospect the schemas every time it reconnects. Would this be possible?
Could you please advise if any of the 3 proposed solutions are in the pipeline? Should I try something else?
请先登录再写评论。
Hi,
There is an issue https://youtrack.jetbrains.com/issue/DBE-5294 you can track and vote for.
Thank you.
@vasily chernov... I AM TRACKING IT AND NO SOLUTION WHATSOEVER! can someone contact me about this? This is very frustrating.