DataGrip 2021.3: Aggregates, Database in VCS, Introspection levels in Oracle

Maksim Sobolevskiy

Read this post in other languages:

• Русский

DataGrip 2021.3 is here! This is the third major update of 2021, and it’s packed with various enhancements. Let’s take a look at what it has to offer! For a detailed description of this update, please visit our What’s new page.

Data editor

• Aggregates
• Table view for tree nodes
• Independent split
• Custom font
• Foreign key navigation by several values
• Setting for default sorting
• Display mode for binary data
• [MongoDB] Completion for filter {} and sort {}

Keeping your database in the VCS

• Mapping the DDL data source and the real one
• Compare and synchronize the DDL data source and the real one in both directions
• File-related actions on the DDL data source
• DDL data source auto-sync
• Setting the default database and schemas for the DDL data source
• New database diff window

Connectivity

• Accidental spaces warning
• [SQL Server] LocalDB as a dedicated data source
• [Oracle, SQL Server] Kerberos authentication
• [Oracle, IBM Db2] Enable DBMS_OUTPUT
• More options button
• Expert options

Introspection

• [Oracle] Introspection levels
• [SQL Server, Oracle] Mapping linked servers and database links to data sources
• [PostgreSQL] Ability to hide system schemas and template databases
• [Snowflake] Support for streams
• [Clickhouse] Distributed tables

Query Console

• Check for boolean expressions
• Extract function for queries
• [MongoDB] Code completion for database names

Services tool window

• Timestamps in output hidden by default
• New activation settings

Import/Export

• New UI for importing data
• First row is header auto-detection
• Automatic column types in CSV files

Miscellaneous

• New Bookmarks tool window

Subscribe to DataGrip Blog updates

Subscribe form

By submitting this form, I agree to the JetBrains Privacy Policy Notification icon

By submitting this form, I agree that JetBrains s.r.o. ("JetBrains") may use my name, email address, and location data to send me newsletters, including commercial communications, and to process my personal data for this purpose. I agree that JetBrains may process said data using third-party services for this purpose in accordance with the JetBrains Privacy Policy. I understand that I can revoke this consent at any time in my profile. In addition, an unsubscribe link is included in each email.

Submit

Thanks, we've got you!