> For the complete documentation index, see [llms.txt](https://docs.autonmis.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.autonmis.com/create-and-manage-your-first-sql-notebook/build-a-sql-notebook-manually.md).

# 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.

<figure><img src="/files/qZVcTfzLNiRf2U7plREf" alt="" width="375"><figcaption></figcaption></figure>

### **Access the SQL Notebook** <a href="#access-the-python-notebook-editor" id="access-the-python-notebook-editor"></a>

When the **"Build Manually"** option is selected, you will be directed to the main SQL notebook workspace.&#x20;

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** <a href="#inserting-code-and-text-blocks" id="inserting-code-and-text-blocks"></a>

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.

<figure><img src="/files/vadmspXtEbHwpbBUYiJE" alt=""><figcaption></figcaption></figure>

### **Working with Code Blocks** <a href="#working-with-code-blocks" id="working-with-code-blocks"></a>

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**

<figure><img src="/files/3kp9At2OMWryUZCzPCie" alt=""><figcaption></figcaption></figure>

### **Additional Features** <a href="#additional-features" id="additional-features"></a>

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**](/create-and-manage-your-first-dashboard/create-dashboards-from-sql-editor-or-sql-notebook/using-sql-notebook.md).

<figure><img src="/files/qOsWFxPjsNetAzEeGUOY" alt=""><figcaption></figcaption></figure>
