Released: Dec 7, 2017

Updates in 2017.3

Features

• Database tree view
  • Group data sources - Press F6 or choose Move to group… from the context menu.
  • Drag-and-drop multiple objects - Now you can drag-n-drop several objects from the database tree view to an editor.
  • Managing schemas - Replaced the Schemas… node in the database tree with the lightweight hover, showing the number of schemas is currently displayed. Click on it to add or hide schemas.
  • New supported objects - Users and roles are now displayed in PostgreSQL and AWS Redshift. Foreign Data Wrappers and as a consequence, foreign tables, are now displayed in PostgreSQL.
• SQL
  • SQL generator - Now it is possible to use the SQL generator to generate DDL scripts with options.
  • PostgreSQL 10 grammar support.
• Executing queries
  • DataGrip now prompts you to choose a database/schema along with a data source when you try to run an SQL file from the context menu.
  • The list of data sources with related consoles will now also appear when attaching the console to a file. 
  • There was only one Execute action before; now there are three of them. Change the behavior, and assign shortcuts: they are completely independent. For example, you can create an action which will execute the whole script, without having to choose the exact query from the script.
  • There is a small improvement for those who didn’t like to use the mouse to choose the schema of the console or the search path. Now there is an action called Set Current Schema. You can invoke it from Find Action (Ctrl+Shift+A).
• Data editor
  • Implement pasting from Excel tables. Generally to do this, it means that you need the ability to paste data in a DSV format. In DataGrip you can define any format you want, or you can let the IDE detect the format automatically.
  • For better readability, the data editor now aligns the numerical data with the right-hand side of the column.
  • Tabs are now restored after re-opening the IDE.
  • The values of two or three cells can be compared in the Diff Viewer. Select them and press Shift+Ctrl+D.
• Connectivity
  • Better SSH support - This build of DataGrip supports:
  • Reading OpenSSH config files (~/.ssh/config and /etc/ssh/ssh_config).
  • Showing dialogue for a One Time Password.
  • Using Ssh-agent and Pageant in authentication.
  • Exasol support
• Navigation
  • Added the option Navigate references to DDL editor.
  • The context menu in the data source was upgraded. Choose Jump to Console and you’ll now have a menu which you will be able to use to quickly switch between consoles.
  • Scratches and Consoles is no longer found in a separate tab, they are now placed in Files.
  • DataGrip 2017.3 provides the ability to replace the selected occurrences in the Replace In Path dialog.
• Other Improvements
  • Synchronize your settings across devices.
  • Time is always displayed in UTC.
  • DDL generation in MySQL works with escaped quotation marks. But the fix can improve performance problems.
  • All the attributes (except obj_file and ink_symbol) are generated in the function DDL for PostgreSQL.
  • Better PIVOT support.
  • Expand column list deals well with table aliases.
  • SQL extractors respect casing setting of the Code style.
  • Ability to choose the current schema for custom database’s query console.