cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

AutoML forecasting with monthly data?

RRO
Contributor

ARIMA and FBProphet have the capability to forecast monthly data.

When using AutoML (via the API or the UI) it seems like it is not possible to have a monthly freq (e.g. 'MS').

Is there a way / workaround to make it work with monthly data or is it planned to add that frequency to AutoML?

1 REPLY 1

MateuszLomanski
New Contributor II

It is possible to use AutoML to forecast monthly data, but it may require some additional steps or adjustments.

One approach is to resample the monthly data to a lower frequency such as weekly or daily, and then use AutoML to forecast at that lower frequency. Once the forecast is generated, you can then upsample it back to the monthly frequency.

Another approach is to use the AutoML's function auto_timeseries_forecast() to train on your monthly data and then use forecast() function to generate predictions with desired frequency. It is not clear whether Databricks AutoML plans to add support for monthly frequency in the near future, but you can check the documentation and community forum to see if there are any updates or plans. It should be noted that, when working with monthly data, it is important to consider any seasonality and trend patterns that may be present in the data, and make sure that the chosen model is appropriate for your use case.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group