#Datagrip documentation drivers#
#Datagrip documentation driver#
#Datagrip documentation full#

Drivers and data sources are now listed on two different tabs.

Improvements in the connection window - Reworked the connection window to make it friendlier:.

CockroachDB dialect support - If you work with the CockroachDB scripts or write SQL to query that database, your code will now be highlighted properly and all errors will be shown before you run the query.

Database introspection and code generation now work properly and are no longer dependent on the functionality of the JDBC driver.

#Datagrip documentation full#

Google BigQuery full support - Full support for Google BigQuery dialect has been added.

#Datagrip documentation driver#

Redshift driver 2.x - The Redshift 2.x JDBC driver is now available for DataGrip users, adding the ability to cancel queries.When it is enabled, the browser will automatically open and let you log in. Microsoft Azure MFA support - Azure Active Directory interactive authentication is now supported.Alt/Opt+Shift+B now highlights the object in the database tree.Alt+Shift+B for Microsoft Windows/Linux.Added a shortcut for the Select in database tree action:.Straightforward actions - Navigation has been simplified:.Transposing single-row results - Added the option to always transpose the result if it contains a single row.The Roll-back and Commit buttons are no longer displayed in automatic transaction mode and there are two new buttons, Revert changes and Find.

New toolbar - Reworked the toolbar in the data editor.It's now also possible to open tables with predefined sorting based on the numeric primary key.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.

If you would prefer to use stacked sorting, click a column name while holding the Alt key. If you click on the name of a column you want to use to sort data, the sorting based on other columns will be cleared. The sorting is not ‘stacked’ by default.A new ORDER BY field works similar to the WHERE field (which was called Filter before): enter a working clause to have it applied to the query of the grid.Better sorting - Improved data sorting:.This can be done either from the context menu of the field or in the value editor. Added the ability to change the type of a field from the UI.A statement preview is now also available. Edit data in MongoDB - Added a crucial feature for working with MongoDB: starting with this version, you can edit data in MongoDB collections.You can also add your own templates or edit the existing ones.You can open the Live Templates settings page and locate the template you need.General Live Templates cover many cases where you need to write a simple query quickly. Context Live Templates - A new solution for anyone wanting to generate simple statements straight from the database explorer.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.Added a UI for editing grants when modifying objects.UI for grants are available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, Microsoft SQL Server and Sybase.