When used with the CREATE MODEL statement, the horizon value specifies the maximum number of points the model can forecast. Once the model is created, the ML.FORECAST statement will specify the number of time points to forecast.
The horizon value exists in CREATE MODEL to help shorten the time it takes to generate the model. If not specified, the model will set a maximum horizon of 1000