DataGrip 2019.1 Help

Work with query results

When you run a query in the console, you receive results in the table format. Each statement appears in a separate tab in the Services tool window. For example, if you have two SELECT statements in the query, you will see two tabs in the tool window.

The Services tool window includes a list of active consoles that are grouped according to a data source. An active console is a console that is opened in the editor. To see a list of active consoles, expand the data source node.

Open a new tab for each query

By default, DataGrip updates the same tab with results each time you run a query. You can change this behavior and create a tab each time you run a query.

  1. In the IDE settings (Ctrl+Alt+S), go to .

  2. Select the Open results in new tab checkbox and click OK.

Open a new tab for each query

Edit values in the result set

  1. In the result set, click a cell value that you want to edit.

  2. Specify a new value and press Enter.

  3. To submit changes to a database, click the Submit icon (The Submit icon), or press Ctrl+Enter.

Modify values in the result set

Export to a file

  • Right-click a result set, select Dump Data | To File.

  • Right-click a query, click Execute to File and select the file type that you want to use for export (for example, Comma-separated (CSV)).

  • On the toolbar, click the Dump Data icon (The Dump Data icon) and select To File.

Export a view to a file

Export to a clipboard

  • Select data in the result set or in the editor and press Ctrl+C.

  • On the toolbar, click the Dump Data icon (The Dump Data icon) and select To Clipboard.

Export a view to the clipboard

Compare two result sets

  1. Select a result set.

  2. Click the Compare with icon (The Compare with icon), and select another result set.

  3. If needed, change a value of the Tolerance parameter in the comparison dialog. The Tolerance parameter defines a maximum number of differences that are allowed between two result sets. For example, if you want to consider two rows as equal if their data differs in a single column, enter 1 in the Tolerance field.

Compare result sets
Compare result sets
Last modified: 17 May 2019