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 R runtime #111

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 R. This aligns SQLMLUtils for SQL Server 2022 with the first phase of the security push.

While the environment is setup to allow R runtime to work with machine learning services in the installed SQLServer2022, there are still some test failures that need to be debugged.

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