Notebook

Overview

Notebook enables interactive analytics with built-in visualization and forms for your Serverless Analytics service.

Prerequisite

  • Serverless Analytics

Access Notebook

  1. Go to the Dashboard.

  2. Click the "CONNECT" button for the Serverless Analytics service.

  3. In the Connect window, click the link under "Getting started using Notebook". You will be directed to the Notebook portal.

Demos

Notebook provides rapid onboarding through step-by-step demos.

From the Notebook portal, you can access four demos located on the right and under the "Notebook" tab:

  1. Click any of the following Demos to get started:

    • Demo-1: Getting Started with Serverless Analytics

    • Demo-2: Schema Inference and Analytics on CSV

    • Demo-3: Interactive Analytics on SkySQL DBS

    • Demo-4: Federate queries across sources

  2. Follow the steps to run each paragraph.

  3. Click the "run" button to run a paragraph (located on the right).

  4. Click the "show editor" button to edit the paragraph.

  5. Click the "hide output" button to hide the returned output.

  6. Click the "gear icon" to adjust the paragraph's font-size, width, location, or run other paragraphs.

Activity Monitoring

Notebook Tools enables you to monitor queries:

  1. Click "Monitoring Console" under Tools.

  2. You are directed to Apache Spark SQL.

  3. All tasks you run are shown in Spark.

Manage Data Sources

Notebook Tools allows you to manage outside data sources:

  1. Click the "Manage Data Sources" button under Tools.

  2. Enter "dataset" name.

  3. Select the data source and file format.

  4. Enter the data source parameters.

  5. Enter File Format parameters.

  6. Click the "Preview Data" button.

Examples

The examples notebook demonstrates simple data transformation. Follow the the Example steps to view the data transformations.

Benchmarking

Notebook allows you to compare Serverless Analytics performance with Data in local NFS vs Data in Xpand cluster (Star Schema Benchmark).

Create New Note

To create a new note in Notebook:

  1. Click the "Notebook" tab in the top navigation bar.

  2. Click the "Create New Note" option in the drop down menu.

  3. Enter a name for the note.

  4. Select desired "Default Interpreter" option.

  5. Click the "Create" button.

Once the notebook is created, you can write queries and notes in the browser.

  1. Click the "run" button to run a paragraph (located on the right).

  2. Click the "show editor" button to edit the paragraph.

  3. Click the "hide output" button to hide the returned output.

  4. Click the "gear icon" to adjust the paragraph's font-size, width, location, or run other paragraphs.

Notebook Task Details

All tasks you run in Notebook are shown in a list in Spark.

To access task details:

  1. In Dashboard, go to your Serverless services.

  2. Click the "connect" button (to the right).

  3. Click the "SQL (Spark) UI" link to view the queries being run.