microsoft / sqlmlutils

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

Add SQL Server 2019 workflow contained on runner VM #110

Closed aaronburtle closed 4 months ago

aaronburtle commented 4 months ago

This PR adds a new .yaml file which will handle the transition of SQL2019 ML Utils from utilizing Azure Resources. This aligns SQLMLUtils for SQL Server 2019 with the first phase of the security push.

Errors that are happening during the running of the pipeline are carried over from the previous SQLMLUtils environment and are related to version updates that need be properly handled. These changes are out of scope for this PR.

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

Successful pipeline run: https://github.com/microsoft/sqlmlutils/actions/runs/9703488737