DataGrip

Versionshinweise: AI Assistant: option to attach schemas AI Assistant now allows you to improve the quality of generated SQL queries by attaching a database schema for context in the chat. For now, only table and column names are attached and there is a maximum limit of 50 ...

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

Versionshinweise: 2023.2 Updated Jul 20, 2023 Features User Interface New UI: The new UI is now enabled by default. Introduced the alternate Light with Light Header option to the Light theme, featuring matching light colors for window headers, tooltips, and notification ...

Versionshinweise: 2023.1.2 Updated May 17, 2023 Features Snowflake The LIKE ALL operator is now supported. New aggregate functions are now supported. The functions MIN_BY and MAX_BY are now supported. Added support for string literals as a body for Snowflake Scripting ...

Versionshinweise: 2022.3.3 Updated Jan 12, 2023 Features Adds auto-refresh feature allowing you to run queries periodically. Setup auto-refresh for sessions in Virtual views to monitor sessions in real time. Added a list of settings to the Object Migration dialog. ...

Versionshinweise: Improves file importing process by adding the option to import multiple CSV files. 2022.2.5 Updated Sep 29, 2022 Fixes Fixed the DataGrip freezing issue that occurred due to INSERT AS SELECT queries. Database renaming now works correctly. [PostgreSQL]: ...

Versionshinweise: Adds support for copying multiple objects along with new logic for canceling statements and stopping connections. 2022.1.5 Updated Jun 7, 2022 Features [Snowflake] Added the ability to skip table stage property introspection if it’s taking too long to get ...

Versionshinweise: Data editor adds the ability to display an aggregate view for a range of cells. 2021.3.4 Updated Jan 19, 2022 Fixes [PostgreSQL, Greenplum, Redshift]: The introspector is now more stable if errors occur. Synonym quick info now displays information about ...

Versionshinweise: Adds DDL data source generation plus improved code highlighting. 2021.2.4 Updated Oct 8, 2021 Features [Vertica] Added support for the LIMIT OVER syntax. [PostgreSQL] Added support for custom search paths inside routine definitions. Fixes [Oracle] The ...

Versionshinweise: 2021.1.3 Updated Jun 8, 2021 Fixes Fixed problem of bad handshakes with old servers: Due to their security policy, Java dropped the usage of the TLSv1 and TLSv1.1 protocols. This caused a problem when connecting to old servers that accept only these ...

Versionshinweise: 2020.3.2 Updated Jan 28, 2021 Fixes The problem with freezes on Test Connection has been fixed. Athena introspection works again. The Submit changes immediately option is back. The JDBC URL is not pasted in the data source name by default. 2020.3.1 ...

Versionshinweise: 2020.2.3 Updated Sep 17, 2020 Fixes The username and password fields no longer disappear. When updating the source code, if a new version contains errors and fails to be submitted, you’ll now see a prompt to restore the previous version. [SQL Server] ...

Versionshinweise: Adds new quick-fix: Refresh Schema. Added new quick-fix: Refresh Schema. If your colleague adds a new object after you have already refreshed your database, this fix will make sure your query is properly highlighted. Renamed migration buttons in schema ...

Versionshinweise: Fixed a time zone error affecting PostgreSQL versions prior to 10. DataGrip no longer refreshes the database after running a query in read-only mode. Targets in the Run Configuration dialog are now filtered by dialect. ...

Versionshinweise: Pasting to the data editor now automatically creates new rows. The data editor tab now appears automatically for CSV files. Pasting to the data editor now automatically creates new rows. The data editor now allows for scrolling beyond the last row. The ...

Versionshinweise: Fixed problem that caused extremely high CPU usage. ...

Versionshinweise: Using Cmd/Alt+1 to open the Database tree view also passes focus to it. Always Select Opened Element in the Services tool window can be disabled. Parts of cells from in-editor results can be copied. ...

Versionshinweise: Adds run configurations and utPLSQL testing framework support. Run configurations Configuration for running script files- Before, you could only run files one by one. This could be especially frustrating if the files included dependencies and the order ...

Versionshinweise: Adds subquery folding feature. Added subquery folding feature. Can't Synchronize Schemas with latest Redshift drivers. CSV/TXT Import to MSSQL Database without importing an id value. "Preview update" does not work when table is not ...

Versionshinweise: The right schema is now used when adding a foreign key constraint to a table. Auto sync is working after a DROP followed by a CREATE statement. No more freezes in JOIN completion. [Oracle] The OracleSqlPlus dialect is back. [ClickHouse] Deleting rows ...