DataGrip 2021.1

4月 06, 2021 - 13:35


  • UI for grants
    • UI for grants are available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, Microsoft SQL Server and Sybase.
    • Added a UI for editing grants when modifying objects.
    • 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.
  • Context Live Templates - A new solution for anyone wanting to generate simple statements straight from the database explorer. General Live Templates cover many cases where you need to write a simple query quickly.
    • You can open the Live Templates settings page and locate the template you need.
    • You can also add your own templates or edit the existing ones.
  • Data Editor
    • Edit data in MongoDB - Added a crucial feature for working with MongoDB: starting with this version, you can edit data in MongoDB collections. A statement preview is now also available.
      • Added the ability to change the type of a field from the UI. This can be done either from the context menu of the field or in the value editor.
    • Better sorting - Improved data sorting:
      • 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.
      • The sorting is not ‘stacked’ by default. 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. If you would prefer to use stacked sorting, click a column name while holding the Alt 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.
      • It's now also possible to open tables with predefined sorting based on the numeric primary key.
    • New toolbar - Reworked the toolbar in the data editor. The Roll-back and Commit buttons are no longer displayed in automatic transaction mode and there are two new buttons, Revert changes and Find.
    • Transposing single-row results - Added the option to always transpose the result if it contains a single row.
  • Navigation
    • Straightforward actions - Navigation has been simplified:
      • Added a shortcut for the Select in database tree action:
        • Alt+Shift+B for Microsoft Windows/Linux.
        • Opt+Shift+B for Apple macOS.
      • If you have the cursor on an object:
        • Ctrl/Cmd+B now shows you the DDL.
        • F4 now shows the data.
        • Alt/Opt+Shift+B now highlights the object in the database tree.
  • Connectivity
    • Microsoft Azure MFA support - Azure Active Directory interactive authentication is now supported. When it is enabled, the browser will automatically open and let you log in.
    • Redshift driver 2.x - The Redshift 2.x JDBC driver is now available for DataGrip users, adding the ability to cancel queries.
    • Google BigQuery full support - Full support for Google BigQuery dialect has been added. Database introspection and code generation now work properly and are no longer dependent on the functionality of the JDBC driver.
    • 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.
    • Improvements in the connection window - Reworked the connection window to make it friendlier:
      • Drivers and data sources are now listed on two different tabs. The list of drivers should not bother experienced users, while helping newcomers 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 before.
      • The DDL data source properties page has a drop-down list for choosing the dialect.
    • The URL field is now expandable which makes it easier to handle long URLs.
  • Database explorer
    • Easy copy-paste of data sources - You can copy, cut, and paste data sources using the shortcuts: Ctrl/Cmd + C/V/X.
      • When you copy a data source, the XML is copied to the clipboard, which you can then share via a messenger. You can also use the Paste action to paste a piece of XML from somewhere else.
      • If you cut and paste a data source inside one project, it will just be moved, no password required. But the password is required in all other cases.
      • A Cut can now be undone with Ctrl/Cmd+Z.
    • New layout - The default layout of the database explorer has been changed, with non-major objects now available under a dedicated node. Secondary objects are now hidden under two nodes: Server Objects and Database Objects.
    • Hide auto-generated objects (Oracle) - If you use Oracle, there is now an option to show or hide auto-generated objects in the tree, including the following:
      • Materialized view logs.
      • The underlying tables for materialized views.
      • Secondary tables.
    • New types of objects (SQLite) - Functions, modules and virtual columns have been introspected for SQLite.
  • Improvements for unsupported databases
    • Data source templates - It is now easier to add the data source for unsupported databases. JDBC drivers are now provided for AWS Athena, Informix, Presto, SAP HANA, Google Cloud Spanner and many others.
      • There are also 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.
    • Queries parsing - Added a new setting for using unsupported databases. When working with these databases in DataGrip, you’ll need to use either the SQL:2016 or Generic dialect. Generic is almost identical to SQL:2016, with just one difference: DataGrip does not highlight any errors it finds.
      • The following values are available to choose from:
        • On valid ANSI SQL statements or by separator – this is the default setting that is suitable for the majority of cases. In other words, DataGrip will do it's best to understand what you want to run.
        • On ANSI SQL Statements – split statements as before. The logic is based only on what DataGrip considers valid based on SQL:2016 grammar.
        • By statement separator – extract and run statements by separators. Use it if the first option didn’t do the job. For GenericSQL, the separator is a semicolon.
          • Please note it is no longer possible to set a custom separator.
      • Upgraded Generic grammar from SQL:92 to SQL:2016.
      • The On valid ANSI SQL statements or by separator option still helps with complex CTEs. This option also helps run things that aren’t statements at all in SQL:2016 grammar, such as show databases.
  • Coding assistance
    • Ambiguous column name when using CTE - The inspection that reports ambiguous column names has become smarter and now takes into account any columns inside common table expressions.
    • System functions can be used unqualified (SQL Server) - System functions and procedures are no longer highlighted as errors when used unqualified. Navigation and completion now work for them as well.
    • JSON Lines support - Thanks to the IntelliJ Platform, DataGrip now has support for the newline-delimited JSON Lines format used for working with structured data and logs. The IDE will now recognize .jsonl, .jslines, .ldjson, and .ndjson file types.
    • Adjustable font weight - The new typography settings help you fine-tune your font style. You can choose the weight of your main and bold font styles.
  • Import/Export
    • Warning about not loaded data - When you copy binary data that hasn’t been completely loaded yet, a notification will now be shown. If you don’t want the data to be truncated, increase the value in the settings.
    • Query in the Microsoft Excel file - When you export to Excel, the resulting file will now contain the query on a separate sheet.
    • First row is header in the context menu - When you import a CSV file, the option to clarify that the first row is a header is now available in the context menu.
  • User interface
    • Attach folder via drag and drop - Added the ability to attach a folder to your project by dragging and dropping it.
    • Maximize tabs in the split view - Whenever several tabs that split the editor vertically are open, you can now double click them and maximize the editor window for each one. To bring the window back to its original size, simply double-click it again.
    • Long names in tabs titles - Added the ability to choose between shortened tab names and long tab names.
UI for grants





今すぐ JetBrains ライセンススペシャリストとライブ チャット