microsoft / sqlmlutils

Utility functions for easier usage of SQL Server Machine Learning Services
Other
32 stars 33 forks source link

Add SQL Server 2022 workflow contained on runner VM with Python #118

Closed aaronburtle closed 2 months ago

aaronburtle commented 2 months ago

This PR adds a new .yaml file which will handle the transition of SQL2022 ML Utils from utilizing Azure Resources by providing support for Python. This aligns SQLMLUtils for SQL Server 2022 with the first phase of the security push.

To demonstrate that the SQL Server 2022 environment is setup correctly we have added a sp_execute_external_script task for Python as well, so that we can validate that the GHA is capable of correctly executing an external script in R using the machine learning services.

Link to successful pipeline run: https://github.com/microsoft/sqlmlutils/actions/runs/9898339030/job/27344914128?pr=118