DataGrip 2021.1 EAP 3
We’ve released our last EAP build before the official release of DataGrip 2021.1. Let’s see what’s new.
Context live templates
This is our solution for anyone wanting to generate simple statements straight from the database explorer. While general live templates cover many cases where you need to write a simple query quickly, 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 use this mechanism for reducing repetitive work, so many newcomers are already used to it.
We’ll start with 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 template Select first N rows from a table.
Open the live templates setting and locate the template you need:
As you can see, it 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:
Obviously, you can add your own templates or edit existing ones, which makes this feature customizable.
Adding grants to user
The Modify user window, which is called by Cmd/Ctrl+F6, now has a UI for adding grants to objects:
This is available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, SQL Server, and Sybase.
Data source templates for unsupported databases
From 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, MemSQL, Presto, SAP HANA, and Google Cloud Spanner. Look for these databases in the Other section of the database list.
We’ve made some additional improvements:
- You no longer need to download the driver yourself and manually create a data source based on it.
- New versions of the driver will be provided by DataGrip.
- Some new databases have their own dedicated icons.
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.
Change field type in MongoDB
To make editing more flexible, we’ve introduced the ability to change the type of a field using the UI. This can be done both in the context menu of the field and in the value editor:
You are welcome to give us feedback using our Twitter or forum. We also have a simple way for you to quickly report issues straight from DataGrip, click Help -> Report problem… to create a new issue in our issue tracker.
Your DataGrip team