DataGrip 2021.1 Help

Release notes

This section lists functionality added to product 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

Data editor: automatic table transposing

Configure when you want to transpose tables and views when you open them in the data editor. In a transposed view, columns and rows are interchanged.

automatic table transposing

Data editor: change field type in MongoDB

In MongoDB, you can change the type of a field in the maximized view or by right-clicking the cell.

Modify data in a separate editor

Data editor: edit data in MongoDB collections

In MongoDB, you can now double-click a cell and modify a value.

When you finished editing, click the Preview pending changes icon (the Preview pending changes icon) to preview your changes.

Preview pending changes icon

Data editor: one navigation shortcut per action

Now DataGrip has separate shortcuts for different navigation actions.

  • Press Ctrl+B to open the DDL of the selected object. For example, if you press this shortcut on a table's name in the SELECT statement, you will see the DDL of this table (the CREATE TABLE statement).

    Go to Declaration
  • Press F4 to open the object data. For example, if you press this shortcut on a table's name in the SELECT statement, you will see the contents of the table.

    EditSource
  • Press Alt+Shift+B to navigate to the object in the Database tool window.

    HighlightObjectInTheDbTree

Data editor: predefined sorting based on the numeric primary key

To configure predefined sorting based on the numeric primary key, open settings by pressing Ctrl+Alt+S and navigate to Database | Data Views. Select the Sort tables by numeric primary key and configure the type of sorting you want: Ascending or Descending.

predefined sorting

Data editor: the stacked sorting for columns is disabled by default

The 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.

stacked sorting

Data editor: WHERE and ORDER BY fields for sorting

The Filter Criteria field was replaced by WHERE and ORDER BY fields.

WHERE and ORDER BY fields for sorting

Database connections: data sources and drivers are separated

Data sources and drivers are separated into different tabs.

data sources and drivers are separated

Database connections: set a dialect for the DDL data source

When creating a DDL data source, you can select a dialect that you want to use for this data source.

set a dialect for the DDL

To create a data source from the Drivers tab, click the Create Data Source link.

Create Data Source</for></control> link

Database connections: the JDBC URL field can be expanded

Click the Expand icon (the Expand icon) if the JDBC URL is too long.

JDBC URL field can be expanded

In the Data Sources and Drivers dialog, you can use the Test Connection link on all the available tabs, not only on General and SSH/SSL tabs.

Test connection link is available on all the tabs

Database support: Azure MFA support

Azure Active Directory interactive authentication is supported. When it is used, the browser will automatically open and let you log in. For more information about connecting to Azure, see Azure SQL Database.

Azure MFA support

Database support: data source templates for unsupported databases

DataGrip includes JDBC drivers for AWS Athena, Informix, MemSQL, Presto, SAP HANA, Google Cloud Spanner, and others. You can find these databases in the Other section of the database list.

For more information about the Other menu, see Creating data sources by using the Other submenu.

drivers-that-have-basic-support

Database support: the Amazon Redshift driver 2.0.0.2

With the Amazon Redshift driver 2.0.0.2 and later, you can cancel running queries.

Database view: configure GRANT privileges for objects

In the Database tool window (View | Tool Windows | Database ), right-click an object and select Modify Object.

Add a user and click the grant field. From the drop-down near each privilege, select Grant or Grant with option. The Grant with option privilege means that a user can grant to or revoke from other users those privileges.

You can autocomplete user names by pressing Ctrl+Space.

Configure GRANT privileges for user accounts

Export: a notification if binary data was not completely loaded

When you copy binary data that has not been completely loaded yet, the Data was copied partially notification is shown.

db_data_was_copied_partially

Export: a query on a separate sheet

When you export to Excel, the resulting file will contain the query on a separate sheet.

Import: the First Row is Header option

When you import a CSV file, the option to clarify that the first row is a header is now available upon the right-click on a header row.

the first row is a header

Inspections: ambiguous column name when using CTE

The inspection that reports about ambiguous column names also takes into account columns inside common table expressions.

ambiguous column name when using CTE

Query consoles: query parsing for unsupported databases

You can customize the query parsing for unsupported databases that use SQL:2016 or Generic dialects. The Generic dialect differs from SQL:2016 in error highlighting. In the Generic dialect, all found errors are not highlighted.

To customize the setting, open settings by pressing Ctrl+Alt+S and navigate to Database | General. Find the Split a script for execution in Generic and ANSI SQL dialects option and select the necessary value.

  • On valid ANSI SQL statements or by separator: DataGrip analyzes a script and splits it on valid statements or by separators. This setting is default.

  • On ANSI SQL statements: split scripts according to the SQL:2016 grammar.

  • By statement separator: extract and run statements by separators. For the Generic dialect, the separator is a semicolon.

Split a script for execution

Search: the Database tab

The Tables tab is renamed to Database.

search everywhere popup

The Database tool window: context live templates

Context live templates is a solution for anyone who wants to generate simple statements straight from the Database tool window. While live templates cover many cases where you need to write a simple query, context live templates take into account the context of the database explorer and the data source that you are using.

In the following animation, we use the Select first N rows from a table context live template for PostgreSQL, Microsoft SQL Server, and MySQL. Depending on a table of a data source, DataGrip generates different queries.

Context live templates

The Database tool window: copying and pasting data sources with shortcuts

You can use Ctrl+C, Ctrl+V, and Ctrl+X to copy, paste, and cut your data sources.

  • When you copy a data source, the XML is copied into the clipboard. You can share it in a messenger or paste in another JetBrains IDE.

  • If you cut and paste a data source inside one project, it will be just moved, no password is required. But the password is required in all the other cases.

  • Cut can be undone via Ctrl+Z.

The Database tool window: groups for server and database objects in the Database tool window

The default layout of the database tree has been changed. Non-major objects are available under a dedicated node. Most of the time users work with tables, views, and routines. Other types of objects like users, roles, tablespaces, foreign data wrappers are not that high on their list of priorities. So, these secondary objects are now hidden under two nodes, Server Objects and Database Objects.

server and database objects

UI and UX: a new toolbar of the data editor

Rollback and Submit and Commit buttons are no longer displayed in automatic transaction mode, and there are two new buttons: Revert Selected and Find on Current Page.

The Revert Selected button reverts changes that you made to a cell value. The Find on Current Page button activates the search field for the current page of results in the data editor.

a new toolbar of the data editor

User management: GRANT permissions for users

In the Modify dialog, you can add GRANT permissions to users. To call the Modify dialog, right-click a user and select Modify Object or press Ctrl+F6.

GRANT permissions for users
Last modified: 06 April 2021