Release notes

Attaching and switching data sources

Now you don't have to attach your SQL files and query consoles to sessions. You can attach them directly to data sources, databases, or schemas that you want to run them against, DataGrip will manage the sessions automatically.

Switching sessiond

In case you need to run something in a different session, you can switch sessions in the Services tool window.

For more information about switching sessions, refer to Manage sessions.

Running functions

You can also select in which session to run a function. The option of selecting sessions is available in the Execute Routine dialog.

Local filter

Rows can be filtered by values in columns using a local filter. The local filter works for a current page and does not send a query to your database.

For more information about filtering data, refer to the Filter data topic.

Move columns in CSV files

Now you can change the position of a column in an attached CSV file by dragging the column when you open the CSV file's data in the table view.

For more information about editing CSV files, refer to Move columns.

Single record view

To work with a single record in the data editor, use single record view. The view will open in the side panel.

For more information about single record view, refer to Single record view.

Aligned code style for multi-row INSERTS

You can now format multi-row INSERT statements with values aligned. The formatter will analyze the width of the values in each column and choose the most suitable width for the column. For the values that are much longer than others, the formatter will make exceptions, moving the remaining fields to the next row.

To turn on and manage this functionality, press Ctrl+Alt+S to open the IDE settings and select Editor | Code Style | SQL | <SQL Dialect>. Open the Queries tab and navigate to the INSERT statement and VALUES clause section.

For more information about the queries code style settings, refer to the reference topic.

Column completion for GROUP BY clause

Now DataGrip analyzes the aggregates used in the SELECT clause and offers you the appropriate column list along with the GROUP BY clause.

Warning for WHERE TRUE clauses

The unsafe query warning now also warns you about running the query with the WHERE TRUE condition or its variations.

Custom characters for code completion suggestions selection

When working with code, you can accept the completion suggestions using custom characters. To set your custom symbols, go to the Editor | General | Code Completion page of the IDE settings  Ctrl+Alt+S, select the Insert the selected suggestion by pressing space, dot, or other context-dependent keys checkbox and enter the characters into the Additional characters to accept the completion field.

Sticky lines

The Sticky lines feature keeps key structural elements, like CREATE statements, pinned to the top of the editor as you scroll.

The feature is enabled by default. To disable it, Press Ctrl+Alt+S to open the IDE settings and then select Editor | General | Appearance. Clear the Show sticky lines while scrolling checkbox.

For more information about this feature, refer to Sticky lines.

JSON documents

JSON documents are now displayed in a dedicated folder. You can view their values in the data viewer, and you can specify the JSON path.

Other data types

Keys of types provided by other modules: RedisTimeSeries and RedisBloom are displayed under the data structures folder.