Create, train, and deploy machine learning (ML) models using familiar SQL commands

Amazon Redshift ML makes it easy for data analysts and database developers to create, train, and apply machine learning models using familiar SQL commands in Amazon Redshift data warehouses. With Redshift ML, you can take advantage of Amazon SageMaker, a fully managed machine learning service, without learning new tools or languages. Simply use SQL statements to create and train Amazon SageMaker machine learning models using your Redshift data and then use these models to make predictions. For example, you can use customer retention data in Redshift to train a churn detection model and then apply that model to your dashboards for your marketing team to offer incentives to customers at risk of churning. Redshift ML makes the model available as a SQL function within your Redshift data warehouse so you can easily apply it directly in your queries and reports.

No prior ML experience needed
Because Redshift ML allows you to use standard SQL, it is easy for you to be productive with new use cases for your analytics data. Redshift ML provides simple, optimized, and secure integration between Redshift and Amazon SageMaker and enables inference within the Redshift cluster, making it easy to use predictions generated by ML-based models in queries and applications. There is no need to manage a separate inference model end point, and the training data is secured end-to-end with encryption.

Use ML on your Redshift data using standard SQL
To get started, use the CREATE MODEL SQL command in Redshift and specify training data either as a table or SELECT statement. Redshift ML then compiles and imports the trained model inside the Redshift data warehouse and prepares a SQL inference function that can be immediately used in SQL queries. Redshift ML automatically handles all the steps needed to train and deploy a model.

Predictive analytics with Amazon Redshift
With Redshift ML, you can embed predictions like fraud detection, risk scoring, and churn prediction directly in queries and reports. Use the SQL function to apply the ML model to your data in queries, reports, and dashboards. For example, you can run the “customer churn” SQL function on new customer data in your data warehouse on a regular basis to predict customers at risk of churn and feed this information to your sales and marketing teams so they can take preemptive action such as sending these customers an offer designed to retain them.

Bring your own model (BYOM)
Redshift ML supports using BYOM for local or remote inference. You can use a model trained outside of Redshift with Amazon SageMaker for in-database inference local in Amazon Redshift. You can import SageMaker Autopilot and direct Amazon SageMaker trained models for local inference. Alternatively, you can invoke remote custom ML models deployed in remote SageMaker endpoints. You can use any SageMaker ML model that accepts and returns text or CSV for remote inference.

Amazon Redshift ML: Simple create model demo (4:56)

Predictive Analytics in Amazon Redshift with Amazon SageMaker

How it works

How it works - Redshift ML(preview)

Customer Success

datacoral - customer logo
“On Amazon Redshift, we reduced our operational costs by 20%. That is a significant win from our previous stack."

Vinesh Kolpe, Vice President of Information Technology - Magellan Rx Management

ZS - customer logo
“Jobcase has several models in production using Amazon Redshift ML. Each model performs billions of predictions in minutes directly on our Redshift data warehouse, with no data pipelines required. With Redshift ML, we have evolved to model architectures that generate a 5-10% improvement in member and member engagement rates across several different email template types, with no inference costs.”

 Mike Griffin, EVP Optimization and Analytics - Jobcase

rackspace - customer logo
“At Rackspace Technology we help companies elevate their AI/ML operations. We’re excited about the new Amazon Redshift ML feature because it will make it easier for our mutual Redshift customers to use ML on their Redshift with a familiar SQL interface. The seamless integration with Amazon SageMaker will empower data analysts to use data in new ways, and provide even more insight back to the wider organization.”

Nihar Gupta, General Manager for Data Solutions - Rackspace Technology

slalom - customer logo

“Slalom is a modern consulting firm focused on strategy, technology, and business transformation. We hear from our customers that they want to have the skills and tools to get more insight from their data, and Amazon Redshift is a popular cloud data warehouse that many of our customers depend on to power their analytics. The new Amazon Redshift Machine Learning feature will make it easier for SQL users to get new types of insight from their data with Machine Learning, without learning new skills.

Marcus Bearden, Practice Director - Slalom

Get started with Amazon Redshift

Amazon Redshift getting started guide
Check out the getting started guide

Follow these steps to load sample data and start analyzing it with Amazon Redshift.

Learn more 
Sign up for a free AWS account
Sign up for a free account

Instantly get access to the AWS Free Tier. 

Sign up