FORECAST (SNOWFLAKE.ML)

A forecast model produces a forecast for a single time series or for multiple time series. You use CREATE SNOWFLAKE.ML.FORECAST to create and train the forecasting model, then use the model’s <model_name>!FORECAST method to produce forecasts. The <model_name>!EXPLAIN_FEATURE_IMPORTANCE method provides information about how each feature in the training data influences the forecast. The <model_name>!SHOW_TRAINING_LOGS method provides error messages for any time series whose models failed to fit. The <model_name>!SHOW_EVALUATION_METRICS method provides evaluation metrics on out-of-sample data.

Important

Legal notice. This Snowflake ML function is powered by machine learning technology, which you, not Snowflake, determine when and how to use. Machine learning technology and results provided may be inaccurate, inappropriate, or biased. Snowflake provides you with the machine learning models that you can use within your own workflows. Decisions based on machine learning outputs, including those built into automatic pipelines, should have human oversight and review processes to ensure model-generated content is accurate. Snowflake provides algorithms (without any pretraining) and you’re responsible for the data that you provide the algorithm (for example, for training and inference) and the decisions you make using the resulting model’s output. Queries for this feature or function are treated as any other SQL query and may be considered metadata.

Metadata. When you use Snowflake ML functions, Snowflake logs generic error messages returned by an ML function. These error logs help us troubleshoot issues that arise and improve these functions to serve you better.

For further information, see Snowflake AI Trust and Safety FAQ.

FORECAST commands

FORECAST methods