Unable to create model

[pranith7867]

I am working on demand forecasting where my timestamp duration is 15 minutes and i have attached sample output to below documents.The issue i am facing is despite setting DATA_FREQUENCY = [AUTO_FREQUENCY].ii am getting the error "Invalid time series: the finest data frequency supported is PER_MINUTE. All input time intervals must be at least one minute" and the query for create model is given below

CREATE OR REPLACE MODEL forecasting.cmc_model

OPTIONS

  (model_type = 'ARIMA_PLUS',

   time_series_timestamp_col = 'date',

   time_series_data_col = 'temperature',

   DATA_FREQUENCY = 'AUTO_FREQUENCY' 

  ) AS

SELECT EXTRACT(DATETIME FROM dateheure) AS date,

valeur as temperature

FROM `stunning-cell-345904.cmc_thermo.releves`

WHERE dateheure >= '2020-12-01' and dateheure <= '2021-02-28'

and idcapteur = 323

ORDER BY dateheure;

[josegutierrez · Accepted solution]

What is happening is that using “AUTO_FREQUENCY” is trying to send the Information as “PER_MINUTE” because of your data, and this needs to have an interval value per minute in each HOUR. You could try with “HOURLY” instead of “AUTO_FREQUENCY”, and it should work.

Instead of:
DATA_FREQUENCY = 'AUTO_FREQUENCY'

Use “HOURLY” or any other DATA_FREQUENCY: 

DATA_FREQUENCY = 'HOURLY'