A CREATE MODEL overview

The CREATE MODEL statement allows for flexibility when addressing the various use cases you may need. There are four main types of CREATE MODEL statements:

• AUTO everything
• AUTO with user guidance, where a user can provide the problem type
• AUTO OFF, with customized options provided by the user
• Bring your own model (BYOM)

Figure 4.2 illustrates the flexibility available when training models with Amazon Redshift ML:

Figure 4.2 – Amazon Redshift ML flexibility

In this chapter, we will provide an overview of the various types of CREATE MODEL statements. Subsequent chapters will provide in-depth examples of how to create all the different types of models, load the data to Redshift, and split your data into training and testing datasets.

In this section, we will walk you through the options available to create models and the optional parameters available that you can specify. All of the examples in...