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 O

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

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 aggreg

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 t

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 k

Important fixes: DBE-11340: The username and password fields no longer disappear. DBE-11156: When updating the source code, if a new version contains errors and fails to be submitted, you'll now see a prompt to restore the previous version.

Hello! This is the first update for DataGrip 2020.2. We’ve fixed some bugs, and here’s a list of the most important ones: DBE-11268: The annoying bug causing the parameters pop-up to appear instead of the context menu has been fixed. DBE-10951: No more freezes when editing CSV files. DBE-10749: Code completion inside OVER clauses works again. DBE-11243: Filters are respected when migrating databases. DBE-10590: No more high memory consumption during export to Excel. Also now DataGrip fully supports the grammar of Greenplum 6.9! DataGrip team

Hello everybody! Today we release DataGrip 2020.2! As usual, we thank all our early adopters who helped us make the IDE better during this release cycle. Here's a brief overview of the new version. For a detailed description of this update, please visit our What’s new page. Data editor — Separate editor for cell values — DML preview in the data editor — New UI for boolean values — New UI for cropped data — Export to the clipboard in the context menu of the data editor SQL editor — Inspection widget — Introduce variable — Suggested rename — Even better JOIN completion — Refresh database quick

This is the release candidate for 2020.2. Check out these publications for a reminder of what's new in this version: 2020.1 EAP 1 2020.1 EAP 2 2020.1 EAP 3 Please try it and share your feedback with us!

Hello, Here is a new build as part of our DataGrip 2020.2 Early Access Program. Google BigQuery dialect We’ve added a new SQL dialect: Google BigQuery. Full support for BigQuery is not here yet, but all things must begin somewhere. So far, DataGrip can correctly highlight and provide coding assistance for your queries if you use Google BigQuery. TextMate bundles TextMate, a text editor for Mac, offers syntax highlighting bundles for many languages. We can import and use them in DataGrip. Starting with this release, the IDE will provide syntax highlighting for the file types register

Introducing DataGrip 2020.1.5! Check out what’s new inside! Most important The issue with SQL Server Authentication on Windows is fixed. Other fixes DBE-9876: Forced execution in read-only mode now runs the correct query. DBE-10727: Schemas comparator respects column order. New features A new quick-fix is available: Refresh schema. If your colleague adds a new object after you have already refreshed your database, this fix will make sure your query is properly highlighted. We have also renamed the migration buttons in the schema comparator to make it clearer what they actuall

Hello! Please welcome the newest build of our DataGrip 2020.2 EAP. Separate editor for cell values Now if you have a huge value in your cell, it can be viewed or edited in a separate panel. You can also toggle soft wrap mode using the right-hand toolbar. DML preview in the data editor Starting with this version, you can review the query that represents your changes in the data editor. This query is not the exact SQL that will be run to modify your data, because DataGrip uses a JDBC driver to update tables, but most of the time it will be the same. So, now you have There is now a DML