DataGrip 2020.3: SQL for MongoDB, Azure AD Auth, New extractors and more

Maksim Sobolevskiy

Read this post in other languages:

• Español
,
• Русский
,
• Português do Brasil

We’re pleased to introduce DataGrip 2020.3. This is the third major update of 2020, and it’s packed with various enhancements. Let’s take a look at what it has to offer!

SQL for MongoDB

• SELECT, FROM, JOIN, WHERE, HAVING, GROUP BY clauses
• Functions and object builders are supported
• JS query preview
• Copy JS query to clipboard

Connectivity

• Couchbase support
• Azure AD authentication
• Working directory

Data editor

• Separate editor for cell values: Formatted value
• Separate editor for cell values: Bottom position
• Separate editor for cell values: Images
• Opening transposed tables
• Shrinking selection

Import/Export

• Introducing two new extractors: One-row and SQL-Insert-Multirow
• Never quote values option

Introspection

• Collect introspection diagnostic information
• Grants
• Changes in the database tree
• [PostgreSQL] More properties for tables
• [Greenplum] New objects
• [Oracle] Correct display of overloaded procedures

Coding assistance

• Formatter for Generic dialect
• Rename options
• Fixing typos
• [Oracle] Inspection for a conflict call

Running queries

• Run configurations: Schema switching
• Run configurations: Displaying the default schema
• Run configurations: History targets
• [SQL Server] Tab names
• Console output in a separate tab
• Hints for indexes in ‘Explain plan’

DDL editing

• Warning for outdated table structure
• Warning if the object was deleted
• Migration actions are available everywhere

IDE general

• The Welcome screen is back
• Per-Project plugins
• Syncing current theme with OS settings
• macOS shortcuts as words
• Preview tab
• Simple calculator
• File associations
• Expand all in the database tree view

To take in all the new features with full descriptions, please visit the What’s New page.
You already know all of this, but just as a quick reminder:

• Get your 30-day trial of DataGrip here.
• Tweet @ us!
• Join the discussions
  in the forum.
• Report bugs to our issue tracker.

Thank you for your attention!
Your DataGrip Team

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!