DataGrip 2020.3 Help

Release notes for DataGrip 2020.3

Processor support: Apple Silicon M1 processors

Starting with the version 2020.3.1 and later, you can use DataGrip on Apple Silicon M1 processors.

Code formatting: code style settings for the Generic dialect

You can customize code style settings for the Generic dialect.

code style to the Generic

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

Data editor: a separate editor for cell values

You can format one-line XML and JSON stings in a 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: 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

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: preview files with a single click

Now you can open a file in a preview tab with a single click. To enable this feature, click the gear icon in the Files tool window view and select both Enable Preview Tab and Open Files with Single Click.

preview files with a single click

Data editor: shrinking the selection

Press Ctrl+Shift+W to shrink the selection.

shrinking the selection

Database connections: MongoDB SSL modes

Starting with DataGrip 2020.3.1, DataGrip includes the MongoDB JDBC driver 1.9 that supports all SSL modes.

Database settings: the working directory option in the Advanced tab

The working directory for the process that handles working with data sources. Also, all relative paths are resolved relatively to this directory (for example, paths in driver properties).

Working directory

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

Database support: Couchbase Query

DataGrip now supports the Couchbase Query Query Service.

Couchbase Query Query Service

Database support: SQL for MongoDB

Instead of writing scripts for the mongo shell in JavaScript, you can use SQL. DataGrip translates SQL to JavaScript for MongoDB automatically. Read more about SQL for MongoDB in SQL for MongoDB.

See translated Javascript code

Database tool window: Submit, Rollback, and Show Changes in the context menu

The Submit, Rollback and Show changes actions are now available everywhere in the context of the object.

Submit, Rollback, and Show Changes in the context menu

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

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

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

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: 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

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

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

Inspections: overloaded functions in Oracle

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

overloaded functions in Oracle

Inspections: a column name is shadowed by an alias

Starting with DataGrip 2020.3.1, you will see a warning if you accidentally missed a comma in your query. The inspection does not highlight explicit aliases (when you use AS). In the following example, the inspection will highlight FIRST_NAME in select ACTOR_ID FIRST_NAME but will not highlight select ACTOR_ID AS FIRST_NAME.

column-name-is-shadowed-by-an-alias

Inspections: inline CTE

Starting with DataGrip 2020.3.1, you can create a subquery instead of using common table expressions. Watch the animation to see how the following code snippet changes.

WITH data AS (SELECT actor.actor_id, first_name, last_name, film_id, fa.last_update FROM actor JOIN film_actor fa on actor.actor_id = fa.actor_id) SELECT * FROM data JOIN film_category fc ON fc.film_id = data.film_id WHERE actor_id = 89;
inline CTE

Introspection: new objects in Greenplum

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

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: 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.3 From 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

Run configurations: updates in the Edit Configuration dialog

The Edit Configuration dialog warns you when scripts contain schema switching. Also, you can choose a target from history. Read more about run configurations in Run files by using run configurations.

Run files by using run/debug configurations

Search: mathematical expressions in Search Everywhere

Press Shift twice and enter a mathematical expression.

Settings: make DataGrip a default application for specified file types

You can make DataGrip the default application for opening specified types of files. To make these associations, open settings by pressing Ctrl+Alt+S and navigate to Editor | File Types.

Last modified: 15 January 2021