| title | Install Python custom runtime | |||
|---|---|---|---|---|
| description | Learn how to install a Python custom runtime for SQL Server using Language Extensions. The Python custom runtime can run machine learning scripts. | |||
| ms.prod | sql | |||
| ms.technology | machine-learning-services | |||
| ms.date | 02/08/2021 | |||
| ms.topic | how-to | |||
| author | WilliamDAssafMSFT | |||
| ms.author | wiassaf | |||
| ms.custom |
|
|||
| zone_pivot_groups | sqlml-platforms | |||
| monikerRange | >=sql-server-ver15||>=sql-server-linux-ver15 |
[!INCLUDE SQL Server 2019 and later]
Learn how to install a Python custom runtime for running external Python scripts with SQL Server on:
- Windows
- Ubuntu Linux
- Red Hat Enterprise Linux (RHEL)
- SUSE Linux Enterprise Server (SLES)
The custom runtime can run machine learning scripts and uses the SQL Server Language Extensions.
Use your own version of the Python runtime with SQL Server, instead of the default runtime version installed with SQL Server Machine Learning Services.
Beginning with [!INCLUDE sssql22-md], runtimes for R, Python, and Java, are no longer installed with SQL Setup. Instead, install your desired Python custom runtime(s) and packages. For more information, see Install SQL Server 2022 Machine Learning Services (Python and R) on Windows or Install SQL Server Machine Learning Services (Python and R) on Linux.
::: zone pivot="platform-windows" [!INCLUDE Python custom runtime - Windows] ::: zone-end
::: zone pivot="platform-linux-ubuntu" [!INCLUDE Python custom runtime - Linux - Prerequisites]
[!INCLUDE Python custom runtime - Linux - Ubuntu specific steps]
[!INCLUDE Python custom runtime on Linux - Common steps] ::: zone-end
::: zone pivot="platform-linux-rhel" [!INCLUDE Python custom runtime - Linux - Prerequisites]
[!INCLUDE Python custom runtime - Linux - RHEL specific steps]
[!INCLUDE Python custom runtime on Linux - Common steps] ::: zone-end
::: zone pivot="platform-linux-sles" [!INCLUDE Python custom runtime - Linux - Prerequisites]
[!INCLUDE Python custom runtime - Linux - SLES specific steps]
[!INCLUDE Python custom runtime on Linux - Common steps] ::: zone-end
You can execute a Python external scripts with the stored procedure sp_execute_external script.
To enable external scripts, use Azure Data Studio to execute the statement below.
sp_configure 'external scripts enabled', 1;
RECONFIGURE WITH OVERRIDE; Use the following SQL script to verify the installation and functionality of the Python custom runtime.
EXEC sp_execute_external_script
@language =N'Python',
@script=N'
import sys
print(sys.path)
print(sys.version)
print(sys.executable)'