Run notebooks and analyze data

• Click on the notebook editor toolbar to execute all paragraphs of the notebook, all paragraphs above or below the current one. The progress of the execution will be shown on the toolbar.

• Click icon in the gutter to execute a particular paragraph of the notebook.

Refresh interpreters

When you execute code of your notebook, you might want to restart an interpreter on the target Zeppelin server. For your convenience, DataSpell provides several options to do this:

• Click on the notebook toolbar.

• Right-click the Run icon in the gutter and select Restart Interpreter.

• Right-click any paragraph in the editor and select Restart Interpreter from the context menu.

Organize data in the table

• Click a column header to order values in it.

• Click to filter data in the selected column.

• Click to organize table in pages. Toggle this button and specify the number of table rows to display on a page: 10, 15, 30, or 100.

• Click and select the columns to be shown in the table.

Export tables

1. Click to save the table in a .csv file.

2. Enter the filename and click Save.

Configure charts

1. Click to alter the initial settings of the chart.

   

2. Click any icon that corresponds to a chart type and the new chart will be plotted. For example, click to add a new scatter chart.

3. Drag the columns you want to plot to the specific field:

   

4. Click the Add new series link to add more series to the chart. Then drag the required columns to the target fields to set the axes.

Export charts

1. Click to save the generated graphical output in the .png format.

2. Enter the filename and click Save.

Configure chart settings

1. To define the way the chart looks, click on the chart toolbar (right side of the output area).

2. Select the contrast or default theme. Click to modify the theme colors. Also, you can click to clone the theme and customize it later.

   

3. Review the modified settings in the preview area and save the changes.

1. In the Zeppelin connection settings, select the Enable ZTools Integration checkbox.

   

2. You can also modify the additional options that define the level of data to be collected:

   • Only collect schema from datasets defined in current note: collects only dataframes that have been defined in the current notebook.

   • Only collect metadata from sql tables occurring in current note: collects only tables whose names occur in string literals in Scala, Python, SparkSQL paragraphs of the current notebook.

3. Download the ZTools library from https://dl.bintray.com/jetbrains/zeppelin-dependencies/org/jetbrains/ztools/ztools-spark-all/0.0.13/ztools-spark-all-0.0.13.jar.

4. Specify the downloaded library as a module dependency for the target Zeppelin connection. See the detailed instruction in Configuring dependencies.

   Note that you must have permission to load Zeppelin dependencies. If you don’t have this permission, the Zeppelin server administrators must add the dependency on their side.

5. Open any notebook on the target Zeppelin server and execute any paragraph to collect data.

6. Once the paragraph is executed, the Variables tab appears in the Zeppelin tool window. You can also see the ZTools synced status in the notebook toolbar.

   

7. In the Variables tab, you can preview the values of the variables. You can right-click any variable to open a context menu and inspect the variable in a separate window with the Inspect ... command, or preview its value in text form (View Text).

   

   At any time, you can click to sync up with the server.