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.
Manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Python, Azure Machine Learning and MLflow.
The Machine Learning extension for Azure Data Studio enables you to manage packages, import machine learning models, make predictions, and create notebooks to run experiments for your SQL databases.