Posted On: May 27, 2021
We're excited to announce that Redshift ML is now generally available. HAQM Redshift ML enables you to create, train, and deploy machine learning (ML) models using familiar SQL commands. With HAQM Redshift ML, you can now leverage HAQM SageMaker, a fully managed machine learning service, without moving your data or learning new skills.
With HAQM Redshift ML powered by HAQM SageMaker, you can use SQL statements to create and train machine learning models from your data in HAQM Redshift and then use these models for use cases such as churn prediction and fraud risk scoring directly in your queries and reports. HAQM Redshift ML automatically discovers the best model and tunes it based on training data using HAQM SageMaker Autopilot. SageMaker Autopilot chooses between regression, binary, or multi-class classification models. Alternatively, you can choose a specific model type such as Xtreme Gradient Boosted tree (XGBoost) or multilayer perceptron (MLP), a problem type like regression or classification, and preprocessors or hyperparameters. HAQM Redshift ML uses your parameters to build, train, and deploy the model in the HAQM Redshift data warehouse. You can obtain predictions from these trained models using SQL queries as if you were invoking a user defined function (UDF) and leverage all benefits of HAQM Redshift, including massively parallel processing capabilities. You can also import your pre-trained SageMaker Autopilot, XGBoost or MLP models into your HAQM Redshift cluster for local inference.
HAQM Redshift ML also provides you the ability to invoke custom ML models deployed in remote SageMaker endpoints.
HAQM Redshift ML leverages your existing cluster resources for prediction so you can avoid additional HAQM Redshift charges. When you create a model in HAQM Redshift, HAQM Redshift ML uses HAQM SageMaker for training your model. You pay only the associated SageMaker costs. There is no additional HAQM Redshift charge for creating or using a model, and prediction happens locally in your HAQM Redshift cluster. View the Redshift pricing page for details.
The Redshift ML is available in the following regions: US East (Ohio), US East (N Virginia), US West (Oregon), US West (San Francisco), Canada (Central), Europe (Frankfurt), Europe (Ireland), Europe (Paris), Europe (Stockholm), Asia Pacific (Hong Kong) Asia Pacific (Tokyo), Asia Pacific (Singapore), Asia Pacific (Sydney), and South America (São Paulo). To get started and learn more, visit the HAQM Redshift documentation or read this blog post.