The required connection property does not found ClusterID
This confusing grammar appeared with Datagrip 2021.3.3 and Redshift driver version 2.1.0.1 [stable]
IAM permissions are set up correctly. Older versions of Datagrip using driver 1.2.16 work fine. Username/password with the same host and port work fine. Only this "AWS Profile" (renamed from "IAM Auth" ?) fails with the odd grammar.
11:09 AM [99999] The required connection property does not found ClusterID
11:09 AM my-redshift.abc123.us-east-2.redshift.amazonaws.com
[99999] The required connection property does not found ClusterID.
My setup looks like this: (hostname edited). It also uses an SSH Tunnel to get into the VPC where the cluster is, again working fine with older version and working fine with username/password to the same cluster.
The error message does not change if I use invalid values for the user and IAM profile.
Please sign in to leave a comment.
I resolved this simply by using the "URL only" connection type, nothing else was required.
Checking the logs, I do see a successful SSH login on the tunnel bastion for each Test attempt, so it is setting up the SSH tunnel before failing...
Please upload logs from Help -> Collect logs and diagnostic data to our server https://uploads.jetbrains.com/ and provide me upload id.
That menu item is a no-op, it does nothing.
EtA: ...if the Data Sources and Drivers window is open. You have to close this window before that menu item works.
Upload ID is 2022_01_07_EwcLc7mbNYgCCWsN
@... this is really holding us back...
Hello I believe I am encountering this same problem. This is the first time I am trying to set up DataGrip and I cannot connect to Redshift using an AWS Profile or a Username/Password. I am on DataGrip 2021.3.4. I am connecting via an SSH (which completes successfully).
As far as I know there is no direct connection to serverless Redshift, so you need to connect via balancer or via ssh jump host.
> you need to connect via balancer or via ssh jump host.
If there is a way to connect via jump host, can you post instructions please?
Fast googling shows the following ways:
Can someone verify that logging into serverless Redshift works with "URL only" connection without ELB/Jump Box?
I tried with "URL only" and I wasn't able to get it working.
When I try with ConnectionType=URL only / Auth=User&Password with JDBC connection string from Redshift dashboard, then I am getting "The connection attempt failed"
When I try with ConnectionType=URL only / Auth=AWS Profile, Profile=MyProfile then also I am getting "[08001] The connection attempt failed"
When I try with ConnectionType=URL only/Auth=IAM then I am getting "Cluster default not found"
Is there any proven way/walkthrough to get this working?
Martin Macak,
Have you enabled public access to your serverless instance?
