DataGrip 2020.2 Help

Release notes for DataGrip 2020.2

Code completion: improved code completion for JOIN clauses

When you start typing JOIN, DataGrip suggests you possible variants at once.

BeforeAfter
Code completion for JOIN clauses before the 2020.2 version
Code completion for JOIN clauses before the 2020.2 version

Also, DataGrip suggests possible JOIN suggestions with two columns.

JOIN suggestions with two columns

Code generation: a new UI to generate a view

In the Database tool window (View | Tool Windows | Database), press Alt+Insert to generate a view.

Generate a view

Database connection: support of native libraries in the driver settings

To work correctly, some JDBC drivers require a path to library files along with the driver.

Possible use cases:

  • For the SSO authentication in Microsoft SQL Server, add a path to mssql-jdbc_auth-<version>-<arch>.dll if you manually set up the driver. By default, SSO authentication works out of the box.

  • To use the OCI driver in Oracle, add a path to the ocijdbc library.

  • To use runtime loadable extensions in SQLite from the query console, add a path to these extensions. In this case, you can omit the full path to them in the query console.

Working with the Native Library Path

Database introspection: faster introspection for Oracle databases

Introspection in Oracle databases is faster.

Database support (BigQuery): initial support

DataGrip can correctly highlight and provide coding assistance for your queries written with BigQuery.

Initial support of BigQuery

Database support (Exasol): analytic functions

DataGrip supports new syntax in Exasol analytic functions (see DBE-11059).

Database support (MySQL): correct highlighting for aliases defined in outer queries

DataGrip highlights aliases defined in outer queries correctly (see DBE-10919).

Database support (Oracle): inline external tables in SELECT statements

DataGrip supports inline external tables in SELECT statements (see DBE-11056).

Database support: the Generic dialect uses SQL:2016 revision of the SQL standard

Instead of SQL-92, the Generic dialect uses SQL:2016 revision of the standard for the SQL database query language.

Editor: a new UI for boolean values

You can select boolean values from the drop-down list in the editor. To select a boolean value, click the cell and select the value that you need from the list.

Alternatively, you can press F, T, D, N, G, or C keys to set the cell value to false, true, default, null, generated, and computed.

The drop-down list for boolean values

Editor: a new UI for cropped data

DataGrip has a limitation for the data size loaded in a cell. To customize this limitation, open settings by pressing Ctrl+Alt+S and navigate to Database | Data views. In the Max LOB length field, type the maximum LOB length in bytes. When the data size exceeds the configured limit, you see the notification that N KB of N KB loaded.

A new UI for cropped data

Editor: a separate editor for cell values

To edit a cell that contains a lot of data, right-click the cell and select Edit Maximized or press Shift+Enter.

Also, you can enable soft wrap in the editor by clicking the Toggle Soft-Wrap button the Toggle Soft-Wrap button.

Expand a cell for editing

Editor: complete one-string values with up or down arrow keys

If you edit a one-line string value in the data editor, press the up or down arrow key to complete editing the value.

Editor: improved usability for long tab titles

In DataGrip, each table opens in a separate tab. The following rules are applied to long tab titles:

  • The Always show qualified names for database objects option is now turned off by default. Tab names for objects are qualified if you open two tabs of objects with the same name. For example, if you open two actor tables from different schemas, the schema name is added in the tab name.

  • If the data source has a name that is longer than 20 symbols, the name is truncated.

  • If you have only one data source, DataGrip does not display the data source name in the tab name.

  • If a qualified object name has more than 36 symbols, it is truncated.

Editor: improved usability for long data source titles

Editor: the DML preview

When you insert, delete, or modify data in a table editor, you can preview the query that DataGrip uses to perform selected operations. To preview the query, click the DML button on the toolbar.

the DML preview

Editor: the Export to the clipboard action is in the context menu

To export the whole result or the entire table to the clipboard, right-click the result or the table and select Export to Clipboard.

In contrast to the Export to Clipboard action, the Copy action only copies the selection.

the Export to the clipboard action is in the context menu

Extractors: enhanced usability of the XML extractor

If the original value is XML, the extractor does not wrap it again in the extracted XML. If the value is not XML, then special characters < and > are converted to the corresponding XML entities: &lt; and &gt;.

Filters: better filtering for MongoDB

In addition to ObjectId and ISODate, filtering now supports UUID, NumberDecimal, NumberLong, and BinData. Also, if you have a valid UUID/ObjectId/ISODate in your clipboard, you will see this value in the offered filters.

Better filtering for MongoDB

Filters: the Show All Namespaces option is added

To display all the available databases and schemas in the Database tool window (View | Tool Windows | Database), click the Show Options Menu button and select the Show All Namespaces option.

EnabledDisabled
Show All Namespaces is enabled
Show All Namespaces is disabled

A database link is an object in the Oracle database that allows you to access objects from another database. A database link can lead to a database that is not an Oracle Database system.

In the Database tool window (View | Tool Windows | Database), you can see Oracle DB links. Also, Oracle database links are correctly highlighted in the editor.

Support of Oracle DB links

Plugins: the TextMate plugin is bundled

TextMate, a text editor for Mac, has syntax highlighting bundles for different languages. You can import a bundle with any language to DataGrip and use it. For more information, see TextMate Bundles

the TextMate plugin is bundled

Quick-fixes: a quick-fix to refresh information about database objects

If you see unresolved objects in your script, click the unresolved object, press Alt+Enter to invoke available intention actions, and select the Refresh schema. If the object exists in the schema, it becomes resolved. This action can help you fix situations when an object was added to the database from somewhere else since the last time you refreshed your database.

A quick-fix to refresh information about database objects

Refactorings: the Introduce variable refactoring

The Introduce variable refactoring is available in Microsoft SQL Server, IBM Db2, Exasol, HSQLDB, Amazon Redshift, and Sybase ASE. You can introduce variables from any expression that has a simple type.

the Introduce variable refactoring

Run configurations: support of run configurations for JavaScript files

If you have MongoDB scripts, you can create Run Configurations from these files.

Support of run configurations for JavaScript files
Last modified: 19 August 2020