DataGrip

DataGrip is a desktop SQL client. Use this page to connect it to your data in DataMind OS: you copy a ready-made data source from the Universe page and paste it into DataGrip. The data source is read-only.

Copy the data source

Open Universe in the sidebar, and find the Integrations section.
On the DataGrip tile, click Copy String.
Wait until the button reads Copied and the Copied to clipboard message confirms the copy.

Note

The Universe page is not available on a phone. Copy the data source from a computer.

The copied text is a full DataGrip data source definition, not a plain URL. Its name and its user name include your email address, and the copy carries no password.

Add the data source in DataGrip

These steps happen in DataGrip, not in DataMind OS. Menu names depend on your DataGrip version, so use DataGrip's own help if a name differs.

In DataGrip, open the Database Explorer.
Add a data source from the clipboard, or paste the copied text into the Database Explorer with Ctrl+V.
When DataGrip asks for credentials, the user name is already set to your email address. Enter your DataMind OS password.
If DataGrip offers to download the ClickHouse driver, let it download.
To query Warehouse data, select the Warehouse databases in the data source's schema settings in DataGrip.

What the data source contains

Setting	What it does	Default
Default database	The database DataGrip opens first.	`information_schema`
Read-only	DataGrip does not let you change data through this data source.	On
Databases shown	The Lake database of each of your roles, named after the role with `_Lake`, for example `HR_Lake`.	Your roles' Lake databases
SSL	Encrypts the connection. Your DataMind OS server sets it.	Follows the server
Socket timeout	How long DataGrip waits for the server to send data.	5 minutes
Keep-alive and auto-close	The keep-alive and auto-close options DataGrip sets on the data source.	On

Who can use it

Any signed-in user can copy the data source. The databases it shows and the data you can read are the ones your roles allow, the same as in the Editor. See SQL dialect and data scope and Roles and permissions.

Limits and edge cases

The data source is built when you click Copy String, so it contains the address you opened DataMind OS with. If that address changes, copy the data source again.
Every copy carries a new ID, so pasting a second copy adds a second data source rather than updating the first. Delete the one you do not need.
Warehouse databases are not included by default. Select them in the data source's schema settings in DataGrip if you need them.
The copy has no password. If you change or reset your password, the new password works in DataGrip too. See Your profile and preferences.
If your account signs in only through single sign-on, set a DataMind OS password first, if your profile offers Set up password. See Your profile and preferences and Connection settings.
DataGrip waits up to 5 minutes for the server to send data, and your account has its own query time limit. See Connection settings for why a long query stops.
If the copy fails, you see Copy failed. See Troubleshooting integrations.

Questions, answered

Why does the copied text fail in a URL field?

The copy is a full data source definition, not a URL. Paste it into the Database Explorer in DataGrip. If you need a URL, copy the JDBC Connection String from Connection settings and use that instead.

Why can I not edit data in DataGrip?

The data source is created as read-only, so DataGrip does not let you change data through it. Use it to read your data.

Why do I only see my Lake databases?

The data source includes the Lake database of each of your roles and no Warehouse databases. To see more, select them in the schema settings of the data source in DataGrip.

What password does DataGrip ask for?

Your DataMind OS password, the one you use to sign in. The copied text never contains it. If your account signs in only through single sign-on, set a DataMind OS password first, if your profile offers Set up password. See Your profile and preferences and Connection settings.

Why did copying create a second data source?

Each copy creates a new data source with a new ID, so pasting it does not update the data source you already have. Delete the one you do not need in DataGrip.

Do I need to set SSL in DataGrip myself?

No. The data source follows the SSL setting of your DataMind OS server. When the server uses encryption, the data source requires it, and you do not change anything.

Can I share the copied data source with a colleague?

No. The copy carries your email address as its name and its user name, so it is set up for your account. A colleague should copy the data source from their own DataMind OS account instead.

Do I need to copy the data source again if the address changes?

Yes. The data source holds the address you opened DataMind OS with. If that address changes, copy the data source again from the new address.