Release notes for DataGrip 2020.3
Database support: Couchbase
DataGrip now supports the 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.
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.
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:
|Before 2020.3||From 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.
Data editor: a separate editor for cell values
You can format one-line XML and JSON stings in the separate editor for cell values.
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.
Data editor: shrinking the selection
Press Ctrl+Shift+W to shrink 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.
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.
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.
The SQL-Insert-Multirow extractor generates a single INSERT statement with multiple new rows to be inserted.
Import and export: never quote values in the CSV format configuration
The CSV configuration has the Never option for the Quote values setting.
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.
Inspections: overloaded functions in Oracle
If you have a call conflict with overloaded functions, DataGrip displays a warning.
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 . 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
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.
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.
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.