DataGrip 2021.2 Help

Release notes

This section lists functionality added to DataGrip in the current release. To view release notes for other DataGrip versions, click the version switcher on the help site and select the version that you need.

Release notes

Code completion: completion for cross-database synonyms

Code completion works for cross-database synonyms.

completion for cross-database synonyms

Code completion: computed columns in INSERT statements

Computed columns are taken into account when completing INSERT statements – they are not included in the suggested item.

computed columns in INSERT statements

Code completion: fields and operators in MongoDB

Code completion for fields in MongoDB supports:

Code completion for operators in MongoDB supports:

CockroachDB: native introspection

CockroachDB is fully supported. The full list of objects that are now introspected includes database, role, privilege, schema, sequence, deftype, table, view, mat view, index, column, and constraints. It’s a known issue that partitions are not introspected yet.

Data editor: shorten tab titles

By default, the Shorten Tab Titles option is enabled. A data source name in the tab title is shortened to 36 characters.

To disable this feature, right-click a tab of a query console and select Shorten Tab Titles.

Shorten names of data sources

Database tool window: a DDL data source from a database

You can generate a DDL data source from any data source that you have (for example, from PostgreSQL). DDL files are generated and saved to your hard drive. A new DDL data source is based on them. If something has changed in the database, you can always regenerate DDL files and update your DDL data source.

Also, you can add new objects to your DDL data source by right-clicking a node of this data source in the Database tool window.

db_create_ddl_data_sources_from_existing_data_sources

Database tool window: linked servers

Linked servers are shown in the Database tool window, and the DDL for their creation can be generated.

linked servers in database tool window

Database tool window: natural sort order for database objects

If you turn off the Sort Alphabetically option in the view options of the Database tool window, the natural sort order for objects is applied.

Sort Alphabetically is enabledSort Alphabetically is disabled
natural sort order is enabled
natural sort order is disabled

Database tool window: separate folders for functions and procedures

In the Database tool window (View | Tool Windows | Database), click the Show Options Menu icon (the Show Options Menu icon) and select the Separate Procedures and Functions setting.

separate folders for functions and procedures

Database tool window: separate nodes for triggers, keys, and indexes

The new database tree option called Place Constraints and Similar Objects under Schema displays separate nodes for triggers, keys, and indexes.

EnabledDisabled
natural sort order is enabled
natural sort order is disabled

Diagrams: the display of table comments and table colors

Diagrams now include table comments and display colors assigned to database objects.

display of table comments and table colors

Diagrams: better layout for diagrams

Object names do not overlap with relation lines.

better layout for diagrams

Editor: context live templates from the data editor

Context live templates work from the data editor. If you are working with a table and you wish to query it, you can use the SQL Scripts context menu action and select the template that you need.

Context live templates also work from the data editor

Editor: Maximize Editor and Normalize Splits actions

The Hide All Tool Windows action (Ctrl+Shift+F12) does not hide split tabs. The Maximize Editor action expands the area of the editor tab, the Normalize Splits allocates equally split tabs and the editor tab.

Maximize Editor and Normalize Splits actions

Editor: search in the local history

You can use text search in the local history if you are looking for a particular revision of your code.

Search in the local history

Editor: settings for stacked sorting

To sort the column data, click the column name. The column sorting is not stacked by default. It means that if you click a column name to sort data by, the sorting based on other columns will be cleared. If you prefer to use the stacked sorting, click a column name while pressing Alt.

To change the default option for stacked sorting, open settings by pressing Ctrl+Alt+S and navigate to Database | Data Views. Change the value for the Add columns to sorting option.

settings for stacked sorting

Editor: snippets for scratch files in a popup

The Show Scratch Files action shows a list of scratches with snippets in a popup.

snippets for scratch files

When you finish importing data, a link to a table with this data appears in the notification area.

link to the new imported table

Introspection: tablespaces, data files, and temporary files in Oracle

We added support for tablespaces, data files, and temporary files. They are displayed in the Database tool window and are included in the DDL generation.

Introspection: virtual foreign keys for pg_catalog

In PostgreSQL, you can use virtual foreign keys and query system tables. Also, the navigation by data now works in system tables. To navigate by data, right-click a cell and select Go To | All Related Rows.

virtual foreign keys for pg_catalog

MongoDB: add and delete operations for columns

You can add columns to MongoDB collections. This action lets you add a new field to any document of a collection.

add and delete operations for columns

If you have foreign keys pointing to the objects in another schema and these objects have the same names, they will be displayed as qualified in the navigation dialog for foreign keys.

Before DataGrip 2021.2, the Enter key opened data for tables or opened consoles for data sources. Now the Enter key expands a node.

Projects: a new location for projects

Starting from DataGrip 2021.2, projects are located in in the user’s home directory, inside the DataGripProjects subdirectory.

To see the Welcome screen each time you open DataGrip, open settings by pressing Ctrl+Alt+S and navigate to Appearance & Behavior | System Settings. Clear the Reopen projects on startup checkbox.

new location for projects

Search: the display of signatures

When searching for a function, procedure, or operator, DataGrip shows signatures in the search window.

displaying of signatures

Settings: Back and Forward buttons in settings

You can use Back and Forward buttons to navigate between different pages in settings.

Back and Forward buttons in settings

Settings: the Disconnect task for the Before Launch section

You can add the Disconnect Data Source task in your run configurations to disconnect from your data source before running the SQL script.

Disconnect task for the Before Launch section

Settings: the display of the Services tool window

You can define which operations make the Services tool window appear. To customize this setting, open settings by pressing Ctrl+Alt+S and navigate to Database | General. Select the necessary setting for the Show Services tool window for query console output.

displaying of the Services tool window
Last modified: 19 October 2021