DataGrip 2022.1

Adds support for copying multiple objects along with new logic for canceling statements.
April 11, 2022
New Version

Features

  • Import/Export
    • Copy multiple objects - Added the ability to select multiple tables and copy them to another schema:
      • Select the tables you want to copy and press F5 to open the export dialog.
      • Like with exporting a single table, you can map the columns, as well as view and change the DDL of the new table.
      • DataGrip supports cross-DBMS export, which means that the target schema can belong to any database in your project. Copying all tables from your PostgreSQL database to Microsoft SQL Server is easy.
      • You can also specify an existing table, instead of a new one, as the target. If you do that, the data from the source table will be added into the target table.
  • Data editor
    • Default display format for binary cells - Added a new setting, Automatically detect binary values, with two options: UUID and Text. UUID detection can now be disabled.
    • Editing fields in query results [MongoDB] - You can now edit the results of queries to MongoDB collections right from a console. This will work even if .find() is followed by methods like sort() or limit().
    • Support for in-editor results in batch mode [Microsoft SQL Server] - When multiple statements are run concurrently in Transact SQL, they are executed in batch mode. Previously, this made it difficult to show in-editor results for each query, but now DataGrip handles this situation well. In addition, DataGrip now removes all SQLCMD statements when running queries in batch mode.
    • Quality improvements:
      • The Enter key now works for saving the value in the date picker.
      • The Tab key is now supported in the date picker.
      • It is now possible to disassociate a .csv file from ‘View as Table’.
      • Made it easier to display hidden columns - simply click on a hidden column in the column list.
      • [Oracle] Timestamp values now respect time zones.
      • [Sybase ASE] All columns are now shown in the result view.
      • The context menu of the column is now also displayed in the Transpose view.
  • Introspection
    • Session templates for introspection - Sometimes introspection requires special permissions, which are granted to special users. It’s now possible to use dedicated credentials for introspection.
    • Fragmental introspection [Oracle] - You can now refresh an object independently of all other objects in the database. This can be especially useful if you are using the new Introspection levels feature. If you need to view the source code of just a single object, you can easily do so by clicking on the Refresh Object button in the database explorer. Also, when you open the object’s source editor, DataGrip will now offer you the option to introspect the selected object.
    • Support for version 2.x [H2] - Added support for H2 version 2.x:
      • The sources are now loaded for views, triggers and routines.
      • Information about check-predicates is now displayed for domains.
    • Added to basic support [YugabyteDB] - The JDBC-driver for YugabyteDB is now included and you can create a YugabyteDB data source with just a single click.
    • Quality improvements:
      • [ClickHouse] The source code of materialized views is now introspected.
  • Code generation
    • New version of Modify Table - The new Modify Table window lets you add and edit column check constraints, which was previously impossible. You can now edit all the properties of tables and columns that are introspected by DataGrip as well.
    • Quality improvements:
      • [MySQL] It is now possible to modify the AUTO_INCREMENT attribute.
      • [Snowflake] The generated DDL script now contains statements for creating the default sequences.
  • Database diff viewer
    • Swap source and target - Added a button that lets you swap the source and the target when comparing objects or schemas.
    • Quality improvements - Improved the quality of the recently introduced database diff viewer window:
      • The diff viewer now detects objects that are likely to be the same even if their names are different.
  • Code editor
    • Convert to subquery intention - Introduced a new intention, Convert To Subquery. You no longer need to use Surround Live Template to convert subqueries. In fact, you don’t even need to bother selecting a query. Simply press Alt+Enter | Convert To Subquery.
    • Better auto-indent algorithm - Improved the auto-indentation algorithms.
    • Multirange types supported [PostgreSQL] - Multi-range types were introduced in PostgreSQL 14 - Added support for the built-in ones. Custom multi-range types will be supported in the future.
    • Quality improvements:
      • [PostgreSQL] Added support for ROWS FROM syntax.
      • [PostgreSQL] Added support for BEGIN ATOMIC.
      • [Amazon Redshift] Added support for ALTER MATERIALIZED VIEW.
      • [Oracle] Added support for USING INDEX ENABLE syntax.
      • [Snowflake] Added support for the WITH TAG option in the CREATE STAGE statement.
      • [Snowflake] Added support for the EXECUTE statement.
      • [Google BigQuery] QUALIFY is now supported.
      • [BigQuery] UNNEST column is now supported.
      • [ClickHouse] Map literals are now supported.
      • [ClickHouse] UNION DISTINCT is now supported.
  • Running queries
    • Canceling running statements - Previously, when you clicked the Cancel statement button several times, it looked like the query was terminated, but in fact the request continued to be executed in the database. The cancellation logic has been made more straightforward. Hopefully, it’s now clearer that it’s the request that is being canceled:
      • The progress indicator on the gutter shows a red square while the request is being canceled.
      • A cancellation progress bar is displayed. It identifies the data source and the session.
    • Data sources are no longer deactivated without a warning, as that can be potentially dangerous for some processes happening simultaneously. So, if you click on the Cancel icon a second time, DataGrip will ask you whether you really want to kill the remote process or whether you’d like to keep waiting. If you choose to deactivate the data source, the query will be stopped for DataGrip, but it will continue to be executed in the database.
      • After 10 seconds of idle canceling, you’ll be offered the option to deactivate the data source anyway.
      • After the query is canceled, a gutter icon that resembles the ‘No’ symbol will appear to the left of it.
  • Canceling connections
    • Previously, when you attempted to abort a request while creating a connection, the data source was deactivated. Now you can interrupt not only the execution of a request, but also the creation of a connection. This is especially relevant for the very first query in the console, which also creates a connection.
    • You can now stop the process of creating a connection without deactivating the data source. If you click the Cancel button while the connection is being created, it will be stopped and a Connection canceled message will be displayed.
  • IDE General
    • Reworked settings - Improved the usability of the structure of the Preferences settings for the Database section. Including:
      • The Track databases/schemas creation and deletion setting has been moved from the General section to Data Source Properties | Options and now refers to a specific data source. This setting identifies whether the schema list needs to be updated after you create or delete schemas in the query console.
      • Other settings are still global but are now included in more appropriate sections.
      • These settings will be reset to their default values as part of this update:
        • Data Source properties | Track databases/schemas creation and deletion – True.
        • Editor | General | Editor Tabs | Database | Always show qualified names for database objects in tab titles – False.
        • Editor | General | Editor Tabs | Database | Shorten datasource and object names in tab titles – True.
    • Evenly split tabs - You can now distribute the working space among editor tabs so that they are the same width.
    • Export UML diagram to other formats - It is now possible to export diagrams as yEd .graphml, JGraph .drawio, Graphviz .dot, Graphviz .dot with positions, Mermaid .md, Plantuml, and IDEA .uml files, which makes them compatible with third-party tools.
    • Quality improvements:
      • Bookmarks now provide the same navigation behavior as database explorer items.
      • Fractional font sizes are now supported.
DataGrip 2022.1
Copy multiple objects

DataGrip

A database IDE that is tailored to suit the specific needs of professional SQL developers and DBAs.

Get Quote Buy Now

DataGrip is also available in:

Got a Question?

Live Chat with our JetBrains licensing specialists now.