What's New in DataGrip 2019.1

In this release cycle, we focused a lot on supporting several new databases.

Greenplum is an analytics database based on PostgreSQL. It is currently developed by Pivotal and the open source community.

Vertica is column-oriented storage designed to handle large volumes of data.

Apache Hive is a data warehouse built on top of Apache Hadoop for providing data query and analysis.

Snowflake is a cloud-based data-warehouse. In 2019.1 DataGrip supports only SQL dialect, the introspection support comes later.

General

We’ve re-arranged the fields here to make the connection process more user-friendly.

The Connection type field is what used to be URL type. It determines the whole UI of this dialog, which is why it’s now on top along with the driver chooser.

The Database field goes after the credentials because sometimes credentials are needed to provide the database list. The list should be invoked by Ctrl+Space

Password saving is now implemented via a drop-down. It has four options: Never, Until restart, For session, and Forever. For Session is probably the only option that requires some explanation: it will save your password until you disconnect from the data source.

Also, the empty password now can be set via the UI; use the context menu to do that.

Options

We’ve moved Read-only, Auto-Sync, and Transaction control settings here, from the General tab.

Newly introduced settings:
– Run keep-alive query each N seconds will help you keep the connection alive. You can define the custom query in the driver settings for unsupported databases.
– Auto-disconnect after N seconds. Pretty self-explanatory.
– Startup script is an SQL query which will be run each time you establish a connection. Remember that if Single connection mode is unchecked, each new console creates a new connection.

Renamed setting:
– Warn if editing an outdated DDL is the new name for what used to be Notify when the outdated object is opened.

Schemas

Object filter has been transferred here from the Options tab.

Data source list

A small enhancement: DDL data sources now have their own group in the data source list inside the connection dialog.

Recent Locations

There’s a new Recent Locations popup that lists your recently visited/changed code locations. It presents them as code snippets with a couple of lines before and after the location.

This popup was inspired by Recent Files, but with an ability to search by visited code locations. This should come in handy when you remember what the code was about but can’t recall where it’s located. Especially if you work with several query consoles: they usually have similar names!

Press Delete/Backspace to remove locations from the popup.

The default shortcut for this popup is Ctrl+Shift+E.

If you’re used to pressing Ctrl+Shift+E to call up Recently changed files, please use double Ctrl+E for that instead.

Find in path

DataGrip can search in source codes of the objects. This was available only if you chose the All Places scope. We’ve cleaned up this UI a little bit and removed the Module and Project tabs.

A new scope, Attached Directories, is available. Use it if you want to search through files in the Files tool window.

Go-to popup

All navigation actions now work from here.

For instance, if you’re searching for a table, see what you can open from right here:
Table’s DDL: Ctrl+B.
Table’s data: F4 (Enter does the same for tables).
Modify Table dialog: Ctrl+F6.
Locate in… popup: Alt+F1 (Use it to see the object in the database tree view).
Quick doc popup: Ctrl+Q.
SQL generator: Ctrl+Alt+G.

There are many more actions related to the objects you see here!

Also, don’t forget about Navigation settings in Database | General. Feel free to create your own flow, as DataGrip now probably covers all possible use cases.

Combined items in completion

We’ve added some combined options to the completion list for CREATE and DROP statements. For example, when you start typing CREATE, you can select CREATE TABLE.

One more benefit is that you can use abbreviations!

This release adds the possibility to fully customize the appearance of the IDE as now you’ll have the power to design your own theme from scratch. We’ve created a few brand new themes to get you started. They can be downloaded as plugins.

You can literally change the color of anything. Create your own theme plugin using the DevKit and modify the IDE appearance via a JSON file. Here are some links that you may find useful:

Detailed tutorial about how to create your own custom theme.

Blog post about creating custom themes for the IntelliJ Platform.

The filter is now a little nicer as it offers to use values from the clipboard.