Managing Amazon Redshift ML
Amazon Redshift ML enables Amazon Redshift users to create, deploy, and execute ML models using familiar SQL commands. Amazon Redshift has built-in integration with Amazon SageMaker Autopilot, which chooses the best ML algorithm based on your data using automatic algorithm selection. It enables users to run ML algorithms without the need for expert knowledge in ML. On the other hand, ML experts such as data scientists have the flexibility to select algorithms such as XGBoost and specify the hyperparameters and preprocessors. Once the ML model is deployed in Amazon Redshift, you can run the prediction using SQL at scale. This integration completely simplifies the pipeline required to create, train, and deploy the model for prediction.
Amazon Redshift ML allows you to create, deploy, and predict using the data in the data warehouse as follows:
Figure 12.4 – Amazon Redshift ML capabilities
Getting ready
To complete this recipe...
