kristeligt-dagblad / dbt_ml

Package for dbt that allows users to train, audit and use BigQuery ML models.
Apache License 2.0
64 stars 26 forks source link

Missing forecast macro for time series Arima model. #27

Open hongyi-rxsense opened 3 years ago

hongyi-rxsense commented 3 years ago

Good job for this dbt_ml package. It is very useful to put our BQ ML ARIMA model into dbt. However, got trouble to forecast, because "ARIMA model is unsupported in ml.predict. Please use ml.forecast instead". Is it possible to add a macro for ml.forecast() in your dbt_ml package, for the case of BQ ML ARIMA model ?

https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-create-time-series https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-forecast