Manage packages in database with Machine Learning extension for Azure Data Studio (Preview)
Learn how to manage Python or R packages in your database with the Machine Learning extension for Azure Data Studio.
Important
Manage packages in database with the Machine Learning extension currently only supports Machine Learning Services on SQL Server 2019.
Prerequisites
Install and configure Machine Learning extension for Azure Data Studio. You need to specify the Python or R installation paths in the Extension Settings for the package management to work.
The sqlmlutils package. If the package is not already installed, the Machine Learning extension will prompt you to install this.
For SQL Server on Linux, Windows authentication is not supported. Therefore, you need to use SQL authentication to connect to your SQL Server on Linux.
Manage Python packages
You can install and uninstall Python packages with the Machine Learning extension.
Install new Python package
Follow the steps below to install Python packages in your database.
Select Manage packages in database.
If you're asked to install sqlmlutils, select Yes.
Under the Installed tab, select Python under the Package Type and select your database under Location.
Select the Add new tab.
Enter the Python package you like to install in Search Python packages and select Search.
Verify the package is listed under Package Name and the desired version is listed under Package Version.
Select Install.
Select Close and verify that the package was installed successfully under Tasks.
Uninstall a Python package
Follow the steps below to uninstall Python packages in your database.
Note
You can only uninstall packages that have been installed in your database. It is not possible to uninstall a package that has been pre-installed with SQL Server Machine Learning Services.
Select Manage packages in database.
If you're asked to install sqlmlutils, select Yes.
Under the Installed tab, select Python under the Package Type and select your database under Location.
Select the package(s) you would like to uninstall.
Select Uninstall selected packages.
Select Close and verify that the package was installed successfully under Tasks.
Manage R packages
You can install and uninstall R packages with the Machine Learning extension.
Install new R package
Follow the steps below to install Python packages in your database.
Select Manage packages in database.
If asked to install sqlmlutils, select Yes.
Under the Installed tab, select R under the Package Type and select your database under Location.
Select the Add new tab.
Enter the R package you like to install in Search R packages and select Search.
Verify the package is listed under Package Name and the desired version is listed under Package Version.
Select Install.
Select Close and verify that the package was installed successfully under Tasks.
Uninstall an R package
Follow the steps below to uninstall R packages in your database.
Note
You can only uninstall packages that have been installed in your database. It is not possible to uninstall a package that has been pre-installed with SQL Server Machine Learning Services.
Select Manage packages in database.
If asked to install sqlmlutils, select Yes.
Under the Installed tab, select R under the Package Type and select your database under Location.
Select the package(s) you would like to uninstall.
Select Uninstall selected packages.
Select Close and verify that the package was installed successfully under Tasks.