DataGrip 2020.3.2 is Out!
Important fixes DBE-12398: The problem with freezes on Test Connection is fixed. DBE-12367: Athena introspection works again. DBE-12168: The Submit changes immediately option is back. DBE-10828: The JDBC URL is not pasted in the data source name by default.
This is the first update for DataGrip 2020.3. In addition to fixing a few bugs, we’ve managed to add a couple of new features. Check them out below. Apple Silicon support Starting from this version we provide builds for Apple Silicon M1 processors. They can be found on the download page for macOS. New features Forgotten comma We've released a new inspection in response to this tweet. If you update, you will no longer bump into this funny situation: Inline CTE We’ve come up with a counterpart for the existing action 'Extract CTE from the subquery' – 'Inline CTE'. Use it to create a subquer
DataGrip 2020.3: SQL for MongoDB, Azure AD Auth, New extractors and more
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
DataGrip 2020.3 EAP 4: Enhancements in Run Configurations, formatter for Generic SQL, Preview tab and more
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
DataGrip 2020.3 EAP 3: SQL for MongoDB
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,
DataGrip 2020.3 EAP 2
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
DataGrip 2020.3 EAP is Started!
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