The DataGrip Blog

The Cross-Platform IDE for Databases & SQL

News Releases

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

Maksim Sobolevskiy

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

Table of Contents

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

Don’t Lose Your Work! Stay Safe With DataGrip DataGrip 2021.2.1

Discover more

Hello, DataGrip 2022.2 EAP build #2 is available. Let’s take a closer look at what’s inside. Playground and Script resolve modes Resolving database objects in SQL scripts takes an understanding of what the objects mean. This is necessary for the IDE to provide you with correct code completion and treat the usages of the objects as links. In general, the resolve context should match the

Hello! Today we’ve got a new minor update for DataGrip 2022.1. Let’s see what’s been improved. Bug-fixes: Thanks! DataGrip team.

Hello! We’re starting our EAP program for DataGrip 2022.2. We would appreciate it if you could try out these new features and share your feedback with us – it will help us make the release better! Let’s take a look at what’s new in the first EAP build. Option to import multiple CSV files You can now select several CSV files and import them at once! New Modify UI The new Modify UI,

We love shortcuts. They make coding faster and more efficient. But they are not always easy to remember. With that in mind, we’ve put together a list of our top-10 most useful DataGrip shortcuts. Execute statement: Cmd/Ctrl+Enter Click the statement or select the fragment of code that you want to execute. It can be a subquery or a group of statements. Press Cmd/Ctrl+Enter. DataGrip execut