Lokasi ngalangkungan proxy:   [ UP ]  
[Ngawartoskeun bug]   [Panyetelan cookie]                
Skip to content

notebooks-manage-sql-server.md

Latest commit

 

History

History
94 lines (60 loc) · 3.67 KB

notebooks-manage-sql-server.md

File metadata and controls

94 lines (60 loc) · 3.67 KB
title How to manage a notebook
description Learn how to manage notebooks in Azure Data Studio. This includes opening notebooks, saving them, and changing your SQL connection or Python kernel.
author markingmyname
ms.author maghan
ms.reviewer achatter, alayu, mikeray
ms.metadata seo-lt-2019
ms.topic conceptual
ms.prod azure-data-studio
ms.technology
ms.custom
ms.date 04/27/2020

How to manage notebooks in Azure Data Studio

[!INCLUDESQL Server 2019]

This article shows you how to open and save notebook files in Azure Data Studio. It also demonstrates how to change your connection to your SQL Server or Python kernel.

Open a notebook

There are several ways to open the Open Notebook dialog. You can use the File menu, the Dashboard, and the Command Palette. The following sections describe each method.

File menu

Select File Open from the File menu Ctrl+O (in Windows) and Cmd+O (in Mac).

Open the Open File dialog by selecting File Open

Dashboard

Click Open Notebook in the dashboard to open the File Open dialog.

Open the Open File dialog by selecting Open Notebook in the dashboard

Command Palette

Use command File: Open from command palette by typing Ctrl+Shift+P (in Windows) and Cmd+Shift+P (in Mac).

Open the Open File dialog by entering File: Open in the command palette

Save a notebook

There's currently one way to save a notebook. Select Save from the notebook toolbar.

Save File by selecting Save in the notebook toolbar

Note

The following methods currently do not save changes to notebooks:

  • File Save, File Save As... and File Save All commands from the File menu.
  • File: Save commands entered in the command palette.

Change the SQL connection

To change the SQL connection for a notebook:

  1. Select the Attach to menu from the notebook toolbar and then select Change Connection.

    Click the Attach to menu in the notebook toolbar

  2. Now you can either select a recent connection server or enter new connection details to connect.

    Select a server from the Attach to menu

Change the Python kernel

The first time you open Azure Data Studio, the Configure Python for Notebooks page is displayed. You can select either:

  • New Python installation to install a new copy of Python for Azure Data Studio, or
  • Use existing Python installation to specify the path to an existing Python installation for Azure Data Studio to use

To view the location and version of the active Python kernel, create a code cell and run the following Python commands:

import os
import sys
print(sys.version_info)
print(os.path.dirname(sys.executable))

To change to a different installation of Python:

  1. From the File menu, select Preferences and then Settings.
  2. Scroll to Notebook configuration under Extensions.
  3. Under Use Existing Python, uncheck the option "Local path to a preexisting python installation used by Notebooks."
  4. Restart Azure Data Studio.

When the Configure Python for Notebooks page is displayed, you can choose to create a new Python installation or specify a path to an existing installation.

Next steps

For more information about SQL notebooks in Azure Data Studio, see How to use notebooks in SQL Server 2019.