Today we’re introducing DataGrip 2021.1, our first major release this year and possibly the most remarkable release in the history of our IDE. We hope you will find that v2021.1 addresses at least one of your pain points, or maybe you will discover a new feature you’ll love, or both. Let’s dive in!
This is available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, SQL Server, and Sybase.
We’ve added a UI for editing grants when modifying objects.
The Modify user window, which you can invoke on a user in the database explorer with Cmd/Ctrl+F6, now has a UI for adding grants to objects:
This is our solution for anyone wanting to generate simple statements straight from the database explorer. General Live Templates cover many cases where you need to write a simple query quickly. But we also understand that sometimes, when you are in the context of the database explorer and you are already focusing on the object you need, there is a better way to get a simple query using that object.
And of course, many other tools also use this mechanism for reducing repetitive work, so many users are already used to it.
Here’s a short video that shows how it works:
Every code snippet in this list is actually a live template, but they are all special ones that can be generated in the context of the chosen object. For example, let's look at the Select first N rows from a table template.
Open the Live Templates settings page and locate the template you need:
Select first N rows from a table looks like a general template (and can be used as such). Since this particular syntax cannot be used in all databases, the corresponding dialects are set for the template. The major difference that makes this template applicable in the database explorer is the special expression dbObjectName, which is used for the $table$ variable:
You can of course add your own templates or edit the existing ones.
In Settings/Preferences | Database | General choose whether you want your script to be generated to the current console or a new one.
We’ve added a crucial feature for working with MongoDB: starting with this version, you can edit data in MongoDB collections. A statement preview is also available.
To make editing more flexible, we’ve introduced the ability to change the type of a field from the UI. This can be done either from the context menu of the field or in the value editor:
We’ve improved the sorting of data:
ORDER BYfield works similar to the
WHEREfield (which was called Filter before): enter a working clause to have it applied to the query of the grid.
If you want to use sorting on the client side (which means DataGrip will not rerun the query, but will sort the data within the current page instead), uncheck Sort via ORDER BY:
It's also possible to open tables with predefined sorting based on the numeric primary key. This setting is placed in Settings/Preferences | Database | Data Views.
We’ve reworked the toolbar in the data editor. The Roll-back and Commit buttons are no longer displayed in automatic transaction mode, and there are two new buttons, Revert changes and Find.
In Settings/Preferences | Database | Data Views now there is an option to always transpose the result if it contains a single row.
We’ve simplified the navigation and got rid of the following settings:
If you’ve never changed these settings and had the checkboxes marked by default, the major change in 2021.1 for you is the following: Go to declaration (Ctrl/Cmd+B) invoked on an object in SQL now takes you to the DDL, not to the database tree.
We’ve also introduced a shortcut for the Select in database tree action: Alt+Shift+B for Windows/Linux and Opt+Shift+B for macOS.
The main reason for this change is to make the logic more straightforward: each action should take you to the place you expect it to.
Now, if you have the cursor on an object:
We understand that some habits might be broken by this, and we’re ready to provide ways to keep your previous experience. Some tips:
database.legacy.navigate.to.code.from.tree. According to our data, very few users used this flow. We also recommend using shortcuts for opening the DDL for objects.
If any use cases are no longer covered by this new flow, please let us know.
Azure Active Directory interactive authentication is supported. When it is enabled, the browser will automatically open and let you log in.
The Redshift 2.x JDBC driver is available for DataGrip users starting with this version. The major enhancement here is the ability to cancel queries.
Support for Google BigQuery dialect was added in the previous release. We’ve expanded it in this release so that database introspection and code generation now work properly and are no longer dependent on the functionality of the JDBC driver.
Now if you work with the CockroachDB scripts or write SQL to query that database, your code will be highlighted properly and all errors will be shown before you run the query. This is the first step to full CockroachDB support, which is coming in one of the future releases.
We’ve reworked the connection window to make it friendlier.
The URL field is expandable now, which makes it easier to handle long URLs.
The ability to copy and paste data sources was introduced a long time ago. But starting with 2021.1, you can copy, cut, and paste data sources using some of the most famous shortcuts in the world: Ctrl/Cmd+C/V/X.
The default layout of the database explorer has been changed, with non-major objects now available under a dedicated node. Most of the time people work with tables, views, and routines, whereas seeing users, roles, tablespaces, foreign data wrappers, and many other types of objects is not high on their list of priorities. So, these secondary objects are now hidden under two nodes: Server Objects and Database Objects.
If you want the old layout back, just select Group Database and Schemas in settings under the gear icon.
If you use Oracle, there is an option to show or hide auto-generated objects in the tree, including the following:
Functions, modules, and virtual columns are introspected for SQLite.
Starting with 2021.1, it’s easier to add the data source for databases we don't support. We now provide JDBC drivers for AWS Athena, Informix, Presto, SAP HANA, Google Cloud Spanner and many others. Look for these databases in the Other section of the database list.
We’ve made some additional improvements:
Please note that support for these databases is limited. It is mainly dependent on the abilities of the JDBC driver and the SQL:2016 dialect support of DataGrip's SQL editor.
We’ve introduced a new setting for using unsupported databases. When working with these databases in DataGrip, you’ll need to use either the SQL:2016 or Generic dialect. Generic is almost identical to SQL:2016, with just one difference: DataGrip does not highlight any errors it finds.
To access the setting, go to Settings/Preferences | Database | General | Split a script for execution in Generic and ANSI SQL dialects. The following values are available to choose from:
Here are some of the problems we’ve resolved:
The inspection that reports ambiguous column names has become smarter and now takes into account any columns inside common table expressions:
System functions and procedures are no longer highlighted as errors when used unqualified. Navigation and completion now work for them, as well.
Thanks to the IntelliJ Platform, DataGrip now has support for the newline-delimited JSON Lines format used for working with structured data and logs. The IDE will recognize .jsonl, .jslines, .ldjson, and .ndjson file types.
The new typography settings help you fine-tune your font style. In v2021.1, you can choose the weight of your main and bold font styles in Settings/Preferences | Editor | Fonts.
When you copy binary data that hasn’t been completely loaded yet, the following notification will be shown:
If you don’t want the data to be truncated, increase the value in Settings/Preferences | Database | Data Views | Maximum number of bytes loaded per value.
When you export to Excel, the resulting file will contain the query on a separate sheet.
When you import a CSV file, the option to clarify that the first row is a header is now available in the context menu as shown below:
It's now possible to attach a folder to your project by dragging-and-dropping it.
Whenever several tabs that split the editor vertically are open, you can double click them and maximize the editor window for each one. To bring the window back to its original size, simply double-click it again.
Some time ago we introduced shortened tab names. Not everyone liked it, so here's a setting to give you more choice.