---
title: Azure Data Studio notebooks (Python, R)
description: Learn how to run Python and R scripts in a notebook in Azure Data Studio with SQL Server Machine Learning Services.
ms.prod: sql
ms.technology: machine-learning
ms.date: 03/09/2020
ms.topic: conceptual
author: dphansen
ms.author: davidph
monikerRange: ">=sql-server-2017||>=sql-server-linux-ver15||=sqlallproducts-allversions"
---
# Run Python and R scripts in Azure Data Studio notebooks with SQL Server Machine Learning Services
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]

Learn how to run Python and R scripts in [Azure Data Studio](https://docs.microsoft.com/sql/azure-data-studio/what-is) notebooks with [SQL Server Machine Learning Services](../what-is-sql-server-machine-learning.md). Azure Data Studio is a cross-platform database tool.

## Prerequisites

- [Download and install Azure Data Studio](https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio) on your workstation computer. Azure Data Studio is cross-platform, and runs on Windows, macOS, and Linux.

- A server with SQL Server Machine Learning Services installed and enabled. You can use Machine Learning Services on Windows, Linux, or Big Data Clusters:

    - [Install SQL Server Machine Learning Services on Windows](sql-machine-learning-services-windows-install.md).

    - [Install SQL Server Machine Learning Services on Linux](../../linux/sql-server-linux-setup-machine-learning.md).

    - [Run Python and R scripts with Machine Learning Services on SQL Server Big Data Clusters](../../big-data-cluster/machine-learning-services.md).

## Create a SQL notebook

> [!IMPORTANT]
> Machine Learning Services runs as part of SQL Server. Therefore, you need to use a SQL kernel and not a Python kernel.

You can use Machine Learning Services in Azure Data Studio with a SQL notebook. To create a new notebook, follow these steps:

1. Click **File** and **New Notebook** to create a new notebook. The notebook will by default use the **SQL kernel**.

1. Click **Attach To** and **Change Connection**. 

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebook change connection](media/ads-attach-to-connection.png)
    
1. Connect to an existing or new SQL Server. You can either:

    1. Choose an existing connection under **Recent Connections** or **Saved Connections**.

    1. Create a new connection under **Connection Details**. Fill out the connection details to your SQL Server and database.

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebook connection details](media/ads-connection-details.png)  

## Run Python or R scripts

SQL Notebooks consist of code and text cells. Code cells are used to run Python or R scripts via the stored procedure [sp_execute_external_scripts](../../relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql.md). Text cells can be used to document your code in the notebook.

### Run a Python script

Follow these steps to run a Python script:

1. Click **+ Code** to add a code cell.

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebooks add code block](media/ads-add-code.png)  

1. Enter the following script in the code cell:

    ```sql
    EXECUTE sp_execute_external_script @language = N'Python'
        , @script = N'
    a = 1
    b = 2
    c = a/b
    d = a*b
    print(c, d)
    '
    ```

1. Click **Run cell** (the round black arrow) or press **F5** to run the single cell.

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebooks run Python code](media/ads-run-python.png)  

1. The result will be shown under the code cell.

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebook Python code output](media/ads-run-python-output.png)  

### Run an R script

Follow these steps to run an R script:

1. Click **+ Code** to add a code cell.

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebooks add code block](media/ads-add-code.png)  

1. Enter the following script in the code cell:

    ```sql
    EXECUTE sp_execute_external_script @language = N'R'
        , @script = N'
    a <- 1
    b <- 2
    c <- a/b
    d <- a*b
    print(c(c, d))
    '
    ```

1. Click **Run cell** (the round black arrow) or press **F5** to run the single cell.

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebooks run R code](media/ads-run-r.png)  

1. The result will be shown under the code cell.

    > [!div class="mx-imgBorder"]
    > ![Azure Data Studio SQL Notebook R code output](media/ads-run-r-output.png)  

## Next steps

- [Quickstart: Run simple Python scripts with SQL Server Machine Learning Services](../tutorials/quickstart-python-create-script.md)
- [Quickstart: Run simple R scripts with SQL Server Machine Learning Services](../tutorials/quickstart-r-create-script.md)