DataGrip 2020.3 Help

Release notes for DataGrip 2020.3

Database support: Couchbase

DataGrip now supports the Couchbase Query Service.

Couchbase Query Service

Database support: Azure Active Directory authentication

This feature applies to DataGrip 2020.3 and later. To use Active Directory authentication, select the Azure Active Directory password option from the Authentication list.

Database support: Azure Active Directory authentication

Introspection: object privileges in DDL

DataGrip knows about object privileges and displays them in the object DDL. This feature works in MySQL, PostgreSQL, Greenplum, Amazon Redshift, and Microsoft SQL Server.

object privileges in DDL

Introspection: TABLESPACE and INDEX ACCESS METHOD in DDL for PostgreSQL

When you press Ctrl+Alt+Shift+B in PostgreSQL, DataGrip will generate DDL with TABLESPACE and INDEX ACCESS METHOD.

Introspection: new objects in Greenplum

In Greenplum, DataGrip shows collations, materialized views, foreign tables, foreign data wrappers, foreign servers, and user mappings.

Introspection: the correct display of overloaded procedures in Oracle

Until DataGrip 2020.3, overloaded procedures in one package were displayed as one item. Now you can see all the procedures. For example, see how the following code is displayed in different version:

create or replace package modifications is procedure old_p(p1 integer); procedure old_p(p1 integer, p2 integer); function old_f(p1 integer) return integer; function old_f(p1 integer, p2 integer) return integer; end modifications; create or replace package body modifications is procedure old_p(p1 integer) is begin return; end; procedure old_p(p1 integer, p2 integer) is begin return; end; function old_f(p1 integer) return integer is begin return p1; end; function old_f(p1 integer, p2 integer) return integer is begin return p1 + p2; end; end modifications;
Before 2020.3From 2020.3
Overloaded procedures until DataGrip 2020.3
Overloaded procedures from DataGrip 2020.3

Introspection: highlighting the changes in the database tree

Until DataGrip 2020.3, you could see that some objects were modified in the Database Changes tool window only. Now modified objects are highlighted in the Database tool window. For example, like the film_not_in_stock procedure in the following screenshot.

highlighting the changes in the database tree

Data editor: a separate editor for cell values

You can format one-line XML and JSON stings in the separate editor for cell values.

Expand a cell for editing

Also, you can preview images in the value editor. Note that the LOB size is limited to 1024 bytes. You can change this value in Database | Data Views.

preview images in the value editor

Data editor: shrinking the selection

Press Ctrl+Shift+W to shrink the selection.

shrinking the selection

Data editor: open transposed tables by default

You can open tables and views in the transposed view by default. It can be useful if the average table in your database has a large number of columns.

To enable this feature, open settings by pressing Ctrl+Alt+S and navigate to Database | Data Views.

open transposed tables by default

Data editor: display tab names for results in Microsoft SQL Server

Starting with DataGrip 2020.3, you can use your own tab names for query results in Microsoft SQL Server.

tab names for results in Microsoft SQL Server

Import and export: one-row and multirow extractors

The One-Row extractor copies a column to a comma-separated string. You can use it to paste a set of values in the IN clause.

One-Row extractor

The SQL-Insert-Multirow extractor generates a single INSERT statement with multiple new rows to be inserted.

SQL-Insert-Multirow extractor

Import and export: never quote values in the CSV format configuration

The CSV configuration has the Never option for the Quote values setting.

never quote values in CSV

Coding assistance: options for the in-line renaming refactoring

When you press Shift+F6 to rename an element, you can click icons near the element and select whether you want to rename it in comments and strings or all the text occurrences.

options for the in-line renaming refactoring

Inspections: overloaded functions in Oracle

If you have a call conflict with overloaded functions, DataGrip displays a warning.

overloaded functions in Oracle

Explain plan: a suggestion to create an index in Microsoft SQL Server

In the Explain plan tool window, DataGrip suggests you to create indexes if it might speed up the query performance.

General: the Welcome screen

When you open DataGrip, you will see the last opened project. If you have not created any projects yet, you will see the default project. To see the Welcome screen, click File | Close Project. You can perform the following actions from the Welcome Screen:

  • Search for projects

  • Customize color themes, IDE fonts, import actions, and sharing preferences

  • Expand the functionality with plugins

the Welcome screen

General: plugins per project

You can enable or disable a plugin only for the current project. A plugin is loaded when you open the project that requires the plugin and unloaded when you close the project.

plugins per project

General: the IDE theme synchronizes with your OS preferences

Depending on your OS preferences, the IDE theme switches automatically between dark and light themes.

To enable this option, open settings by pressing Ctrl+Alt+S and navigate to Appearance & Behavior | Appearance.

General: collect diagnostic information

Sometimes introspection might run into problems. Use Diagnostic menu items to collect troubleshooting data and pass it on to our support team. You can read more about diagnostic tools in Collect information by using Diagnostic tools.

collect diagnostic information
Last modified: 17 October 2020