Replacing a SQL Table Name in a Python Jupyter Notebook Query

  This SOP provides a step-by-step guide for updating a SQL table name in a query within a Python Jupyter Notebook. This is useful when the table name in the database has changed and you need to reflect that change in your notebook code.

1. Open your Jupyter Notebook:

   - Press the Windows key.

   - Type 'Jupyter Notebook' and press Enter. 

   - Navigate to the folder containing your notebook and open the .ipynb file.

2. Locate the cell containing the SQL query:

   - Scroll through the notebook to find the cell where the SQL query is written.

   - The query will typically be inside a Python string.

3. Identify the old table name in the SQL query:

   - Look for the FROM clause in the SQL query.

   - Example: SELECT * FROM old_table_name

4. Replace the old table name with the new one:

   - Click inside the cell to edit it.

   - Change 'old_table_name' to 'new_table_name'.

   - Example: SELECT * FROM new_table_name

5. Run the updated cell:

   - Press Shift + Enter to execute the cell.

   - Verify that the query runs successfully and returns the expected results.

6. Save your notebook:

   - Click File > Save and Checkpoint or press Ctrl + S.

7. Close Jupyter Notebook:

   - Click the browser tab close button or press Alt + F4.

   - In the terminal window, press Ctrl + C to shut down the notebook server.