Creating forecasting models using Redshift ML
Currently, if you have to perform forecasting in your data warehouse, you need to export the dataset into external systems and then apply forecasting algorithms to create output datasets and then import them back into the data warehouse for your presentation layer or further analysis. With Redshift ML’s integration with Amazon Forecast, you don’t have to perform all these steps. You can now create the forecasting models right on your dataset within your data warehouse.
In Chapter 5, we talked about the basic CREATE MODEL
syntax and its constructs. Let’s take a look at the CREATE MODEL
syntax for forecasting:
CREATE MODEL forecast_model_name FROM { table_name | ( select_query ) } TARGET column_name IAM_ROLE { default | 'arn:aws:iam::<AWS account-id>:role/<role-name>' } AUTO ON MODEL_TYPE FORECAST [ OBJECTIVE optimization_metric ] SETTINGS (S3_BUCKET 'bucket', &...