DataGrip 2020.2 Help

Release notes for DataGrip 2020.1

Amazon Redshift: support for the syntax of materialized views

Support for the syntax of materialized views has been added. You can use the following commands with Amazon Redshift: CREATE MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW, and DROP MATERIALIZED VIEW.

Code inspections: a date injection and a date value inspection

If you use DATE before a string literal to convert it, DataGrip understands that this string contains a date and highlights it accordingly. If you use wrong values for the date, DataGrip highlights them as a warning.

This feature works in MySQL, Oracle, IBM Db2, and H2.

A date injection and a date value inspection

Connectivity: new authentication options for PostgreSQL and Microsoft SQL Server

PostgreSQL now supports the pgpass password file. You can read more about the password file in The Password File article at postgresql.org.

Using the pgpass file

For the Microsoft SQL Server on the jTds driver, DataGrip now has the Authentication list, where you can select the authentication type:

  • User & Password requires a username and a password.

  • Windows credentials requires you to run DataGrip on Windows in the same domain as the Microsoft SQL Server database. Works as the Single Sign-On (SSO).

  • Domain credentials requires a domain, a username, and a password.

Select the authentication type

Connectivity: shared SSH configurations

Now you can create a configuration of the SSH tunnel and share it between data sources or projects.

Sharing of SSH connection settings

Database colors: text data viewer uses the color of the data source

The text data viewer uses the color of the data source. To set a color, right-click a data source and select Color Settings. In the Database Color Settings dialog, select the dialog and coloring options. To have the data source color applied for query consoles and grids, select the In console editors and grids checkbox.

Text data viewer uses the color of the data source

Database tool window: a dedicated node for trigger functions

The trigger functions now have a separate node in the Database tool window (View | Tool Windows | Database).

Database tool window: automatically attach the folder with source files for a DDL data source

When you create a DDL data source, the folder with SQL files for this data source is automatically attached in the Files tool window.

Automatically attach the folder with source files for a DDL data source

Editor: introduction of the Mark as plain action

When DataGrip opens a script file, it indexes the file, applies syntax highlighting, and enables coding assistance. These operations are CPU-consuming, and you may experience some performance issues when you view or edit such files.

In DataGrip 2020.1, you can mark large script files as plain text, and then open them for editing. Highlighting and coding assistance will be disabled but you can modify the file with no performance lags.

A new design of the Export Data dialog

Editor: the Data tab appears automatically when you open CSV files

When you open a CSV file, you can click the Data tab at the bottom of the editor to switch to the table mode.

the Data tab appears automatically when you open CSV files

Editor: new rows are created automatically when you paste them

When you paste new rows into a table, the table expands to include all the pasted rows.

New Rows Are Created Automatically When Pasted

Editor: spacing after the table

Spacing is added after the table, so you can scroll below the end of the table.

Spacing After The Table

Editor: the Refresh schema quickfix

If your colleague adds a new object after you have already refreshed your database, the new object might be highlighted in your code (as the missing object). You can press Alt+Enter in the editor and select Refresh schema.

Spacing After The Table

Export: a new design of export settings

A list of export settings received a new look.

DataGrip 2019.3DataGrip 2020.1
Export settings in DataGrip 2019.3
Export settings in DataGrip 2020.1

Export: a new design of the Export Data dialog

The Export Data dialog has a new look.

A new design of the Export Data dialog

Export: export to Excel

You can export your output results to the XLSX file.

To export a table to the XLSX file, click the Export Data to File button (the Export Data to File button). In the Export Data dialog, select Excel (xlsx) from the Extractor list and click Export to File.

Export to Excel

Export: the file name is preselected in the Export Data dialog

In the Export Data dialog, when you click or navigate to the File name field the filename becomes preselected.

File Name Is Preselected In The Export Data Dialog

Import: the Import file action in the context menu for CSV

The Import file action is now available:

  • In the context menu of the CSV file, and

  • In the context menu of the editor when a CSV file is opened.

the Import file action in the context menu for CSV

Import: a notification about changes in the table DDL

If you try to change the DDL of the target table during the data import process, DataGrip displays a notification to confirm that you really want to perform this action.

db import change ddl notification png

Intention actions: introduction of the Preview update action

By using the Preview update intention action, you can preview the output of your UPDATE statement. DataGrip displays columns with the new values next to the old ones.

Preview of the UPDATE statement

Migrations: renamed Migrate Left or Migrate right actions

Migrate Left or Migrate right actions are renamed to Apply Right to the Left and Apply Left to the Right.

Migrate Left or Migrate right actions are renamed

MongoDB: improved coding assistance

MongoDB now has a better completion of methods and enhanced resolve and completion of collection names.

Better coding assistance for MongoDB

MongoDB: introduction of the Filter by action

You can use the Filter by action from the context menu to filter column values.

The Filter by action is available in MongoDB

MongoDB: collections with the bracket notation are resolved correctly

You can use the bracket notation with MongoDB. The following two commands generate the same output:

db.collection.find(); db['collection'].find();

Oracle: a notification about expired passwords

In Oracle, you can change an expired password from the interface of DataGrip. This feature is available for Oracle 12.2 and later with the standard JDBC driver. With the OCI driver, this feature works for old versions as well.

Running code: introduction of in-editor output results

When you run a script in the editor, you see the output results below the query. This feature is called In-editor results. To disable this feature, open settings by pressing Ctrl+Alt+S and navigate to Database | General. Clear the Show output results in the editor checkbox.

Disable in-editor results globally

Running code: introduction of Run configurations

In DataGrip 2020.1, you can create a configuration to run several files at once or just a couple of statements.

When you work with multiple files, you can reorder them, add new files, and run other programs or configurations before launch.

Run several files by using run/debug configurations

If you want to run a couple of statements, you can create a configuration to run script code and type your code in the text field.

Run a script by using run/debug configurations

Searching: introduction of a data source context scope

You can search for an object in the context of the data source with which you are working. To enable this option, select Context Data Sources from the All Places list. The filter is available for Tables, Files, and Symbols tabs.

The context is defined according to the console that you use, the data editor, or a data source that you selected in the Database tool window. If you select several data sources, the search is performed in all of them.

Context Data Sources

Testing: support of utPLSQL and Tsqlt test frameworks

DataGrip now supports the following test frameworks: utPLSQL and Tsqlt.

  • Run utPLSQL tests: learn how to run utPLSQL tests in the Oracle environment.

  • Run tSQLt tests: learn how to run tSQLt tests in the Microsoft SQL Server environment.

Usability: the File | Open menu attaches a directory

To attach a directory, navigate to File | Open and select the directory in the file browser. You can find the attached directory in the Files tool window (View | Tool Windows | Files).

Usability: easy navigation to Execute settings

If your file contains several queries, when you run one of them you see the Statements window (a chooser). You can navigate from the chooser to Query Execution settings by clicking the Customize link.

Easy navigation to Execute settings

Viewing data: the Geo viewer for geospatial data in PostgreSQL

The Geo viewer is a graphic viewer that you can use to explore geospatial data in your database.

The Geo Viewer

Viewing data: the text data viewer

You can view the table data as a simple text. To switch to the Text mode, click the View as button (the View as button) and select Text.

The transposed table viewing mode

Viewing data: the CSV file type is registered in DataGrip

DataGrip now has a registered CSV file type. This means that you will no longer get a notification about CSV supporting available plugins.

Also, you can switch to a table view by using an icon in the editor. When you apply settings in the Edit as Table dialog, you will see two tabs for the file: Text and Data. Text presents data in a text format, Data in a table format.

Edit CSV in the table view
Last modified: 10 July 2020