Build a SQL Notebook Manually

If you opt for the 'Build Manually' method, follow these steps:

Input Details

• Enter the Objective of the notebook.

• Select the relevant Tables (multiple selection allowed) from the dropdown.

• Once completed, click 'Generate' to proceed.

Access the SQL Notebook

When the "Build Manually" option is selected, you will be directed to the main SQL notebook workspace.

A default SQL code block is automatically created, where you can begin writing and executing SQL code to generate outputs.

Inserting Code and Text Blocks

As you navigate through the notebook, you can easily add more content using the following options located in the each code block:

• + SQL: Allows you to insert SQL code blocks to query data directly within the notebook.

• + Text: Adds a text block to include notes or explanations.

All changes are saved automatically to ensure no progress is lost during your work.

Working with Code Blocks

Each code block provides options to:

1. Run the query

2. Modify variable names

3. Use AI Copilot for suggestions (pencil icon)

4. Hide the Code, move up/down, or delete the step

Additional Features

At the top of the notebook, you'll find CTAs:

1. Publish or Share using the vertical ellipsis menu

2. Save the notebook

3. Show all Variables

4. Run all code blocks

5. Notebook tab (default view)

6. Storybook tab: Displays the notebook's analysis in narrative form

7. Dashboard tab: To create a Dashboard using SQL Editor, the user can click on this link.