Released: Dec 6, 2023

Updates in 2023.3

Features

Data visualization

• Added the ability to visualize data using the Lets-Plot library integration. The visualization is available on all three types of grids:
  • Main tab: When you open the table, view, or CSV file, the plot is displayed in split mode.
  • Result tab: When you observe the result of a query in the Services tool window, the plot can be displayed instead of the grid.
  • In-editor results: You can display the plot instead of the grid.

New import functionality

• The import functionality has been reworked. Some features to highlight:
  • Mapping
    • The default target entity is called mapping. Here, you can define the target table and map the file columns with the columns of the target table. If you need to edit the table itself, click the Edit button.
    • The table will appear in the tree UI on the right. This UI completely repeats the Modify Object UI, letting you manipulate the table and its objects in various ways.
  • Auto-generate table names - This button automatically generates the table name from the source file. It can be useful if you rename a table but then want to revert to its default name.
  • Simplify column name - This action can be useful when the original column names contain spaces.
  • Ability to revert to the old UI - Added the option to revert to the old UI if you wish to.

Working with data

• Customizable number formats in the data editor - There is now much greater flexibility in how you can see numbers in the data editor. Most significantly, you can specify decimal and grouping separators. Other options include the ability to define how infinity and NaN will be rendered.
• Ability to render numbers as UNIX timestamps - In the UNIX timestamp format, timestamps are stored as numbers, expressing how many milliseconds have elapsed since January 1, 1970 (UTC). This format is now supported in DataGrip.
• [Microsoft SQL Server] Support for import/export tables via BCP - Added support for the BCP tool, which lets you export and import tables in SQL Server.

DynamoDB support

• Added support for DynamoDB. The following has been implemented so far:
  • DynamoDB data can be viewed via DataGrip's data viewer.
  • PartiQL for DynamoDB support in the code editor.
  • Tables with keys and indexes are now introspected.

Introspection

• Introspection scheduler - You can now set an introspection interval for each data source.
• [Oracle] Introspection level defaults - DataGrip takes a long time to introspect schemas in Oracle because Oracle catalogs are generally pretty slow. To address this problem, introspection levels were introduced.
  • By default, the highest level was selected. This meant that introspection only began at the third level for selected schemas, which was slow. What's more, some users were unaware that the introspection level setting existed at all.
  • This release prioritizes user experience and performance over fullness of functionality. The default introspection level value is now set to Auto Select.
  • Added fragmental introspection – the ability to retrieve metadata for one single object. This helps in situations where the metadata (usually, the source code) is explicitly requested by the user.
• [SQL Server] Support for new objects - New objects are supported in SQL Server:
  • Partition functions and partition schemes.
  • Partitions and related table/index properties.
  • Ledger tables.
  • Filegroups.
• [Redshift] Support for materialized views - Materialized views in Redshift are now introspected and displayed in a dedicated node in the Database Explorer.

Running queries

• [Oracle] Support for ref cursors in the query console - You can now get the result from ref cursors if you run the query in the console or in the SQL file.
  • If the function you run returns a result containing only one ref cursor, DataGrip immediately navigates to the result from the ref cursor.
  • In more complex cases where the result contains several ref cursors or something other than a ref cursor, DataGrip shows the main result and gives you the opportunity to view results from other ref cursors. From the cell with the ref cursor, you can go to the corresponding result set (Enter/Double-click) and vice versa (Ctrl+B).

Code generation

• Enable/disable database objects - Some types of objects can be enabled and disabled. From now, DataGrip supports performing this via the UI, letting you generate and run the corresponding code pieces. This feature is applicable for:
  • [MySQL] Events.
  • [PostgreSQL] Rules, triggers, and event triggers.
  • [MS SQL] Indexes, Foreign keys, check constraints, and triggers.
  • [Oracle] Keys, uniques, foreign keys, check constraints, triggers, tablespaces, and user accounts.

Miscellaneous

• SQLite Warning if using WSL path - Unfortunately, it is impossible to work with the SQLite database located under a WSL path. The reason is that WSL doesn't respect the SQLite file locking mechanism. For now, the only available solution for DataGrip is to show a warning in that particular case.