Here’s a glimpse of what awaits you in the latest version. For a full overview of this update, please visit our What’s Newpage.
AI Assistant
AI Assistant can now generate SQL code right in the editor.
AI Assistant can also help you with modifying your database tables in the Modify dialog.
You can also use the AI Assistant intention actions to better understand and fix SQL problems.
You can now add database schemas to the AI chat simply by mentioning them in your prompt.
You can now add files from an attached folder to provide scripts to AI Assistant as context for AI chat.
Working with data
You can now import data from your tabular data files. We’ve implemented scripted loaders to enable importing for the following file formats:
Excel
JSON
Parquet
Shapefile
The Geo Viewer now supports CSV and XLSX files.
Navigation to Related Rows and opening web links is now possible via a floating toolbar.
Value completion is now automatic.
You can now select all values in a column by clicking on the column’s header.
Search Everywhere popup
There are now two ways to filter search results by database object type: either by using the filter icon or by using commands.
The popup now also includes an option to preview the codebase elements you’re searching for.
Working with scopes is now more efficient thanks to the additional data source scope and the improved location of data source scopes at the top of the list.
Connectivity
The performance of the Auto sync feature has been improved for SQL Server and Oracle.
The built-in IDE macros are now available to use in your connection startup scripts.
Non-RSA certificates are now supported for SSL connections.
Snowflake Iceberg, dynamic, and hybrid tables are supported.
If you’re interested in upgrading to DataGrip 2024.2, or if you have any questions or suggestions, here are a few links you might find useful: