Shkarko DataGrip 2024.2

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.
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.