How to reveal database schema on datagrip

[MrM4tthew]

i successfully connect my db with jetbrains datagrip editor, but when trying to open the schema it show this error

i don't really understand what happened, I have used the connection parameters shown on my cluster but it just doesn't show the schema. Funny thing, when I manually query the data like this

it shows the table inside the schema. Can somebody help me?

[jordanlewis]

You need to make sure to specify your cluster name in your connection string. Could you share the settings you've used to connect?

Use the settings here to populate in datagrip:

Like this:

Does that help?

[MrM4tthew]

i have previously specified the cluster name in my connection string

Just like this:

still show the same error, I can CREATE and SELECT the table using the query console but can not manage to visualize it with the datagrip UI. I think the problem is not with me not specifying the cluster name because clearly I have typed it.

[MrM4tthew]

@jordanlewis

[jordanlewis]

@MrM4tthew, the problem is that JetBrains opens connections to the DB without including the DB in the connection string every time. To resolve this, you should

1. change the database to connect to to just be defaultdb
2. set the value of the options parameter in the Advanced tab to --cluster=matthew-bennett-355

This should resolve the problem, please let me know if it works for you.

We will be working on documenting this more clearly.

[MrM4tthew]

finally, it works like a charm.