Store Python Models in SQL Server for your ETL Processing
In this video we'll show how you can generate a very basic Machine Learning Model in Python, then store that model in SQL Server so that we can call on it and use it as part of an ETL process.
First we generate a model using pure Python, then we migrate that into SQL Server's sp_execute_external_script procedure.
From here we can export the generated Python Model into a SQL Server table.
Once stored, we can use that Model to process data within our ETL in order to classify data prior to making the data live, allowing us to better clean and normalise our data within the ETL process.
Check out our other videos as well, we cover basic PowerShell and Docker alongside our SQL Server based content and we're hoping to expand out further into Power BI, Python, R and other areas.
Please don't forget to Like and Subscribe.
I'll make sure I put all code onto the company blog so that everything in the video can be reproduced.
Kutech.co.uk - Our one stop SQL shop for Training, Consultancy, and Remote DBA and Support Services
Auf dieser Seite können Sie das Online-Video Store Python Models in SQL Server for your ETL Processing mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Kutech Solutions Ltd 28 April 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 205 Mal angesehen und es wurde von 5 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
