DataGrip 2022.2

Improves file importing process by adding the option to import multiple CSV files.
July 25, 2022
New Version

Features

  • Option to import multiple CSV files
    • Improved the file importing process by adding the option to import multiple CSV files.
  • Playground and Script resolve modes
    • Added two new resolve modes: Playground and Script:
      • In Playground mode, DataGrip resolves all objects to the context, which is the value in the schema chooser, resolution scope, or default database. It works best if your file is just a set of unconnected queries, independent of each other and in no particular sequence. Playground mode is now the default for query consoles.
      • In Script mode, the beginning of the file is resolved to the context, but any USE statements in the script change the context for the resolve because they are part of the script’s sequential logic. This is a good choice for when your queries have sequential logic and should be run as a single script. Script mode is now the default for local files.
  • Code generation
    • New Modify UI - The new Modify UI is now the default option. Starting with this release, all of a table’s child objects can be added and edited using this new UI. The old UI will remain available through this release cycle via the context menu.
    • Added support for collations and charsets [Microsoft SQL Server] - Collations and charsets are now generated with the table’s DDL.
  • Categories in the keymap
    • Previously, all of the actions related to database functionality were stored in four different places in the keymap. This structure, which has very little logic, was a historical consequence of the IDE’s development. To help you see all of the available actions, the structure has been re-arranged and all of the actions in groups have been placed under the Database parent group.
  • Scopes in DDL data sources
    • You can now set file scopes as sources for DDL data sources. This will let you easily filter folders for the DDL data sources.
  • Miscellaneous
    • Merge All Project Windows action on Apple macOS - Added the ability to merge all open project windows into one, turning them into tabs. This action is available from the Window menu.
    • Password expiration warning [Oracle and Vertica] - Oracle and Vertica databases can provide warnings if the password is going to expire. DataGrip now retrieves this information and displays it after Test Connection is activated.
    • Added basic support for DuckDB, Mimer SQL and Apache Ignite - Added 3 new databases to the basic support list: DuckDB, Mimer SQL, and Apache Ignite.
  • Data editor
    • Quality improvements:
      • When opening the Quick Documentation for cells, the related data is loaded automatically.
      • Operator family matching is now supported.
      • [Microsoft Azure SQL Database] SET ROWCOUNT is now executed before Azure queries to limit page size.
  • Query console
    • Quality improvements:
      • [ClickHouse] MODIFY ORDER BY is now supported for ALTER TABLE.
      • [SQL Server] CHANGETABLE is now supported.
      • [SQL Server] END CONVERSATION is now supported.
DataGrip 2022.2
Import multiple CSV files

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.