Build a SQL Notebook Manually
Last updated
Was this helpful?
Last updated
Was this helpful?
If you opt for the 'Build Manually' method, follow these steps:
Enter the Objective of the notebook.
Select the relevant Tables (multiple selection allowed) from the dropdown.
Once completed, click 'Generate' to proceed.
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.
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.
Each code block provides options to:
Run the query
Modify variable names
Use AI Copilot for suggestions (pencil icon)
Hide the Code, move up/down, or delete the step
At the top of the notebook, you'll find CTAs:
Publish or Share using the vertical ellipsis menu
Save the notebook
Show all Variables
Run all code blocks
Notebook tab (default view)
Storybook tab: Displays the notebook's analysis in narrative form
Dashboard tab: To create a Dashboard using SQL Editor, the user can click on this .
