Summary

In this chapter, we discussed classification models in detail and looked at their common use cases. We also explained the CREATE MODEL syntax for classification models, where you provide guidance to train a model by supplying the model type and objective.

You learned how to do binary classification and multi-class classification with Amazon Redshift ML and how to use the XGBoost and linear learner algorithms. We also showed you how to check the status of your models, validate them for accuracy, and write SQL queries to run predictions on your test dataset.

In the next chapter, we will show you how to build regression models using Amazon Redshift ML.