# Running a Notebook from Another Notebook using Fusion SQL

SingleStore Notebooks support running one notebook from another using [Fusion SQL](https://docs.singlestore.com/cloud/reference/fusion-sql.md), either within the same session or in a new session. This is useful when you want to:

* Avoid code duplication such as reusable functions or environment setup by running the shared logic in a separate notebook.
* Run code in parallel by executing notebooks in separate sessions.

## Create a Sample Notebook

You can create a sample notebook in one of two ways:

* On the [Cloud Portal](https://portal.singlestore.com/) select **New** > **New Notebook **> **Shared**. 
* Run the following Python code in a notebook:
  ```python
  import nbformat as nbf

  nb = nbf.v4.new_notebook()

  cell = nbf.v4.new_code_cell("""# This is a code cell
  if 'sample_var' not in globals():
      sample_var = 'sample value'
  print('Sample Notebook has been executed!')""")

  cell.metadata = {
      "language": "python"
  }

  nb.cells.append(cell)

  # Save the notebook to a file
  with open('sample_notebook.ipynb', 'w') as f:
      nbf.write(nb, f)

  print("Notebook 'sample_notebook.ipynb' created successfully in the local filesystem.")
  ```

## Example Notebook

The following notebook shows how to run a notebook from another notebook with Fusion SQL:

## Upload the Notebook to Shared Notebooks in the Editor

This step generates a unique notebook name by appending a timestamp to the notebook filename to avoid naming conflicts.

Skip this step if you already created a Shared notebook via the UI in the first step.

```python
import time

sample_notebook_name='Sample Notebook {}.ipynb'.format(int(time.time() 
* 1_000_000))

%sql UPLOAD SHARED FILE TO '{{ sample_notebook_name }}' 
FROM 'sample_notebook.ipynb';

print("Notebook '{}' has been created in the Editor shared 
files.".format(sample_notebook_name))
```

## Run the Notebook in the Current Session

Use `%run_shared` to execute the sample notebook in the current session. Confirm that the `sample_var` variable set in the sample notebook is accessible in the current session.

```python
if 'sample_var' in globals():
    del sample_var

%run_shared {{ sample_notebook_name }}

print("The value of 'sample_var' is '{}'.\n".format(sample_var))
```

**Note**: If you created the shared notebook via the UI, replace `sample_notebook_name` in the code above with the actual notebook name in single quotes:

```python
% run_shared {{ 'Sample Notebook.ipynb' }}
```

## Run the Sample Notebook in a New Session

You can also run the sample notebook **in a new session** using jobs. This allows you to execute multiple notebooks in parallel using `RUN JOB USING NOTEBOOK`.

Refer to [RUN JOB USING NOTEBOOK](https://docs.singlestore.com/cloud/reference/fusion-sql/run-job-using-notebook.md) for syntax and more information.

```python
job_ids = []
for x in range(2):
    print("Running job for {}...".format(x))
    job_res = %sql RUN JOB USING NOTEBOOK '{{ sample_notebook_name }}' WITH PARAMETERS {"sample_var": "{{x}}"}
    job_ids.append(job_res[0].JobID)

print(f'Waiting for jobs to complete... {job_ids}')
success = %sql WAIT ON JOBS {{ job_ids }} WITH TIMEOUT 60 MINUTES

print(f'All jobs completed with success: {bool(success[0].Success)}')
```

**Note**: If you created the shared notebook via UI, replace `sample_notebook_name` in the code with your notebook name in single quotes (no brackets):

```sql
%sql RUN JOB USING NOTEBOOK 'Sample Notebook.ipynb' WITH PARAMETERS {"sample_var": "{{x}}"}
```

## View Job Executions

Use `SHOW JOB EXECUTIONS` to inspect job runs.

```python
for job_id in job_ids:
  execs = %sql SHOW JOB EXECUTIONS FOR {{ job_id }} from 1 to 1
  print(execs)
```

## Delete the Jobs

Use `DROP JOBS` to delete the jobs.

```python
for id in job_ids:
    print(f"Dropping job '{id}'...")
    %sql DROP JOBS {{id}}
```

**Note**: You can also view, inspect, and delete jobs from the **Jobs** section in the left navigation on the Cloud Portal. Refer to [Scheduling Notebooks with SingleStore Job Service](https://docs.singlestore.com/cloud/container-services/scheduled-jobs.md) for more information.

## Delete the Sample Notebook

Delete the sample notebook using `DROP SHARED FILE`, or via the Cloud Portal by selecting **Delete** from the **Actions** column for your notebook.

```sql
%%sql
DROP SHARED FILE '{{ sample_notebook_name }}'
```

***

Modified at: May 19, 2026

Source: [/cloud/container-services/notebooks/running-a-notebook-from-another-notebook-using-fusion-sql/](https://docs.singlestore.com/cloud/container-services/notebooks/running-a-notebook-from-another-notebook-using-fusion-sql/)

(An index of the documentation is available at /llms.txt)