DataGrip 2020.2 Help

Create and edit notebooks

When you have installed the required plugins and established connections to the servers, you can start working with your notebooks.

Right-click any notebook in the Big Data Tools window to open the context menu for the basic operations with the notebook. You can also use the following shortcuts:

ActionShortcut
CopyCtrl+C
PasteCtrl+V
CutCtrl+X
MoveF6
RenameShift+F6
Move to trashDelete

Creating notebooks

You can create a new notebook on the target server (remote notebook) or in the current DataGrip project (local notebook).

Create a remote notebook

  1. In the Big Data Tools window, right-click any of the configured servers or a folder and select Create Note from the context menu or press Alt+Insert.

  2. In the Create note dialog, enter the name of the notebook. You can use the / symbol to create a notebook within a folder. Click OK.

    Creating a remote notebook

    The newly added notebook appears in the Big Data Tools window.

    Newly added notebook

In DataGrip, you can create notebooks that are stored locally.

Create a local notebook

  1. In the Project tool window, select the project root, press Alt+Insert, and select Zeppelin Notebook.

  2. In the Create Zeppelin Notebook dialog, enter the notebook name and press Enter.

    Create a local notebook

    The newly added local notebook appears in the Project tool window.

    Newly added notebook in the Project window

Editing notebooks

Once you create a notebook, it opens in the editor. The newly added notebook has one executable paragraph marked with the % delimiter.

Newly added notebooks in the editor

Type sql next the delimiter to enable SQL coding.

Press Enter and start editing your notebook right away.

Any time you need to add more paragraphs or delete the current paragraph, just press Alt+Enter and select the required action:

Available actions for the current paragraph

You are not limited to adding only SQL code paragraphs. For example, to add any markdown code, just add md right after the delimiter.

Note, that you don't need to save your edits. Auto-saving is triggered by various events, for example, closing a notebook or a project, or quitting the IDE.

Manage interpreter bindings

Once you have added code to your notebook, you're ready to execute it and analyze the data. However, you can customize the interpreters used to execute paragraphs by the target server.

  1. On the notebook editor toolbar, click Interpreter bindings.

  2. In the Interpreter Bindings dialog, use the arrow buttons to alter the priority of an interpreter.

    Interpreter bindings
    You can also deselect an interpreter and explicitly disable it or restart any interpreter when, for example, the corresponding session got expired.

Last modified: 30 September 2020