# 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="https://1640066561-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3UjpVP9YQLo2slTy7qQ1%2Fuploads%2F4gRL7p6KqbbPyt4JSF8r%2Fimage.png?alt=media&#x26;token=c20e265e-ff97-446e-8f44-9684b6b313a3" 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="https://1640066561-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3UjpVP9YQLo2slTy7qQ1%2Fuploads%2F97s1VSibhHqosxGLjYwH%2Fimage.png?alt=media&#x26;token=22d42380-6d8e-4efd-b338-95909438692c" 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="https://1640066561-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3UjpVP9YQLo2slTy7qQ1%2Fuploads%2FkvtUYclKhce4MrEywcS0%2Fimage.png?alt=media&#x26;token=d0169db3-d5b3-4d1c-92a7-c46401268c5a" 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**](https://docs.autonmis.com/create-and-manage-your-first-dashboard/create-dashboards-from-sql-editor-or-sql-notebook/using-sql-notebook).

<figure><img src="https://1640066561-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3UjpVP9YQLo2slTy7qQ1%2Fuploads%2FKipqnfrNimznOSnSPQHv%2Fimage.png?alt=media&#x26;token=4adab456-18fa-4b88-b39e-853242b05b2f" alt=""><figcaption></figcaption></figure>
