DataGrip 2021.2: Creating DDL data sources from real ones, Better diagrams, Search in Local History

Maksim Sobolevskiy

Read this post in other languages:
Русский

DataGrip 2021.2 is here! This is the second 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.

DDL data source

• Generation from a real data source
• Creating objects

Diagrams

• Table comments are now visible
• Table colors are also displayed on the diagram
• Ability to turn off edge merges

Code editor

• Search in Local History
• Local History for sources
• Long tab names are back
• Maximize Editor / Normalize Splits action

Code completion

• Completion scope
• [MongoDB] Completion of fields and operators
• [SQL Server] Completion for cross-database synonyms
• INSERT completion and computed columns

Code highlighting

• [Redshift] Support for recursive CTE
• [ClickHouse] Better CTE support

Database explorer

• Separate folders for functions and procedures
• Separate nodes for triggers, keys, and indices
• Natural sort order for database objects

Introspection

• [CockroachDB] Native introspection
• [PostgreSQL] Virtual foreign keys for pg_catalog
• [Oracle] Tablespaces
• [SQL Server] Linked Servers

Data editor

• Context live templates from the data editor
• Additive sorting option
• [MongoDB] Add/delete column
• Add/rename columns in CSV files
• Copy query to console
• No more First row option in navigation by foreign keys
• Qualification in navigation by foreign keys

Import/Export

• Table link after import

Navigation

• Behavior of the Enter key in the navigation bar
• Signatures in the Go To popup

General

• Localized UI
• New location for projects
• Back and forward buttons in Settings
• Advanced Settings
• Show scratch files action
• Managing the Services tool window popups

Download DataGrip 2021.2

DataGrip team