DataGrip 2019.3 Help

Intention actions

As you work in the editor, DataGrip analyzes your code, searches for ways to optimize it, and detects potential and actual problems.

As soon as the IDE finds a way to alter your code, it displays a yellow bulb icon yellow bulb icon in the editor next to the current line. By clicking this icon, you can view intention actions available in the current context. Intention actions cover a wide range of situations from warnings to optimization suggestions. You can view the full list of intentions and customize them in the Settings/Preferences dialog Ctrl+Alt+S.

A red bulb with an exclamation mark the Quick-fix icon indicates that DataGrip has detected a problem, and prompts you to select an associated fix — a quick-fix.

Apply intention actions

  1. Click the light bulb icon (or press Alt+Enter) to open the list of suggestions.

  2. Select an action from the list and press Enter.

    For example, you can use an intention action in the INSERT statement to create a table with valid field types:

View all intention actions

You can view the full list of available intention actions, and disable actions that you do not need:

  1. In the Settings/Preferences dialog Ctrl+Alt+S, go to Editor | Intentions.

  2. For each intention action, you can see a description and an example. To disable an intention, clear the checkbox next to it.

    Available intention actions
  3. Apply the changes and close the dialog.

Disable intention actions on the fly

  1. Click the light bulb icon (or press Alt+Enter) to open the list of suggestions.

  2. Select the action you want to disable, and click the right arrow.

  3. Select Disable <intention action name>.

    Disable intention action

Examples of intention actions

Introduce a table alias

  1. Place a caret after the table name for which you want to create an alias.

  2. Press Alt+Enter.

  3. Select Introduce table alias.

  4. Type the alias name.

Apply a quick-fix by hovering a cursor

if DataGrip knows how to fix the problem, you will know about it by just hovering the mouse over the warning. To fix the problem just click the link at the lower left corner of the tooltip. Alternatively, press Alt+Enter and apply a corresponding action.

Apply a quick-fix by hovering a cursor

Replace GROUP BY with DISTINCT

You can convert GROUP BY to DISTINCT if all the columns of the SELECT clause are presented in the GROUP BY clause. To convert the GROUP BY statement, place the caret at GROUP BY, press Alt+Enter, and select Replace GROUP BY with DISTINCT.

Convert GROUP BY to DISTINCT
Last modified: 13 April 2020