Amazon announces Redshift ML during re:Invent 2020, introducing database professionals to the world of machine learning through SQL.

Photo by fabioha on Unsplash

Throughout the years, Amazon continues to add and improve on their current stack of machine learning (ML) related services bringing ML capabilities closer to more and more people. To highlight a few, in 2017, AWS unveiled Amazon SageMaker — a service that looked to aid users throughout their entire ML model building and deployment process. In early 2020, Amazon launched Aurora ML; the service allowed Aurora database users to utilise SQL syntax to make predictions using ML models deployed through SageMaker. …

Photo by twinsfisch on Unsplash

AWS Redshift Smart Pause and Resume

AWS Redshift Smart Pause and Resume is a serverless tool aimed to automate when to pause and resume a Redshift (single and multi-node) cluster. The tool makes use of a number of AWS services including Lambda Functions, Amazon Forecast, Step Functions and Cloudwatch Metrics and Events, and all are deployed together using the serverless framework.

What’s it for?

Last month AWS unveiled the ability to pause and resume Redshift clusters. Overall, this feature now allows users to completely shut down a Redshift cluster at times when it is not utilised, thus lessening the costs associated. This is particularly useful for Redshift clusters used…

image source link

Recently, Amazon launched a new machine learning capability to Aurora Databases called Aurora Machine Learning. The introduction of this new feature now allows Aurora database users to call, make predictions and inferences with machine learning models by simply using SQL. Specifically, Amazon Comprehend can be called on text data to do sentiment analysis. Alternatively, custom-built machine learning models deployed through SageMaker can also be utilised to make predictions and inferences as well. Being able to do this does help with a number of different use cases such as product recommendation or customer churn analytics. Ultimately, in the end, I think…

Adelbert Choi

Data Engineer at Servian

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store