Jordan Lewis
Jordan Lewis

Reputation: 17918

How do I connect JetBrains DataGrip to CockroachDB Serverless?

I'd like to use JetBrains DataGrip with CockroachDB Serverless.

How do I create a connection? I get errors that look like this:

[08004] FATAL: codeParamsRoutingFailed: missing cluster name in connection string.

Upvotes: 0

Views: 555

Answers (2)

--cluster= Identifies your tenant cluster on a multi-tenant host. For example, funny-skunk-123. This option is deprecated. hostThe in the connection string now includes the tenant information.See screenshot

Upvotes: 0

Jordan Lewis
Jordan Lewis

Reputation: 17918

Use the following configuration to connect to CockroachDB Serverless from JetBrains DataGrip (or other JetBrains IDEs).

General configuration panel

The key tricky part is that you need to add the cluster name to the options parameter in the Advanced tab, as shown here. Replace cluster-name-1234 with your cluster name and ID, as shown on your CockroachDB Serverless Connect screen.

enter image description here

Upvotes: 6

Related Questions