Features

Hello! We’re starting our EAP program for DataGrip 2021.2. We would really appreciate you trying out these new features and sharing your feedback with us – it helps us make the release better! Let's go! DDL data source Generation from a real data source It is now possible to generate a DDL data source based on a real one. The DDL files will be created on the disk and the new data source will be based on them. That way you'll always be able to regenerate these files and refresh the DDL data source.Let's take a look at how it works.The new menu item Dump to DDL data source is added to t

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 rep

Hello! Here’s yet another build in our EAP for DataGrip 2021.1. Navigation Straightforward actions We've simplified the navigation and got rid of these settings: If you never changed these settings and had these check-boxes marked by default, the major change in 2021.1 for you is the following: Go to declaration (Ctrl/Cmd+B) on the object in SQL now leads you to the DDL, not to the database tree. We 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 reasoning behind this change is the idea that the logic sho

If you’re interested in previewing what the year’s first release of DataGrip will include, here’s what you can already try. Connectivity We’ve reworked the connection window to make it more friendly. Drivers and data sources are now listed on two different tabs. The list of drivers won't bother experienced users, while newcomers will not confuse them with data sources. Every driver's page includes a Create data source button. The Test Connection button has been moved to the footer so that you can use it from any tab of the data source properties, not only the General and SSH/SSL tab as

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 transpose

Hello! We’ve got something new for you in this fresh EAP build. Run configurations We’ve introduced new usability features to help you when running scripts. DataGrip will warn you if a script contains schema switching. If you choose just a data source as a target, DataGrip will show in which particular schema the script will be run. It is the default schema. We also added the possibility to choose a target from history: click the small button with the clock. Formatter for Generic dialect Enjoy our SQL formatter when working with unsupported databases! DDL editing The Submit, Rollbac

Hello! In this post about our third EAP build for 2020.3, we'll describe just one feature – but it’s a huge one: SQL for MongoDB TL;DR – You can now use SQL to query MongoDB databases. Only SELECT queries work. Working сlauses: JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET. SELECT Options you can use: DISTINCT, ALL. You can use aggregate functions: AVG, SUM, MIN, MAX, and others. Columns can be qualified. Restrictions COUNT (expression) is not yet supported. You can't use aggregate functions, such as AVG, SUM, MIN, and MAX, as if they were not aggregate. For example,

Hello! We've got something new for you in this fresh EAP build. Azure AD authentication The DataGrip community has been asking for this for a while! You can now use Azure AD to log in to your database. Collect introspection diagnostic information Introspection is the process by which DataGrip retrieves information about a database. This information is used to show the objects in the database explorer, display their DDLs, suggest them during completion, and so on. Sometimes introspection runs into problems. Now, when things go wrong, you can collect useful data that you can pass on to our su

For those of you who are eager to try the newest things, we invite you to join our Early Access Program for DataGrip 2020.3. As you may know, these builds don’t require a license – we just want everybody to try the new features out before the official release. Let’s go! Couchbase support We're always happy to welcome a new database into our family, and our newest member is Couchbase! It's important to mention that DataGrip supports the Couchbase Query service, not the Couchbase Analytics service. Introspection Grants The most important enhancement in this aspect is that DataGrip now knows ab