How to Forecast in Databricks SQL with ai_forecast
Forecasting usually means exporting data, training a model and writing the results back, so many teams skip it. The ai_forecast function in Databricks SQL does the forecast in one query, and version 2 adds holiday support, covariates and non-negative forecasts on top of a time series foundation model. This guide builds a daily sales forecast step by step: you prepare the input, run a basic…
We haven't written up this one. Dev.to has the full story — the link below goes straight to it.
Source: dev.to