5 ms·
Time Series Forecasting in SQL
- sdepablos 5y agohttps://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-forecast https://cloud.google.com/bigquery-ml/docs/reference/standard...
- speedgoose 5y agoI recently tried this in a Google tutorial, it was very nice, but I was surprised to learn in the same tutorial that Google Cloud AutoML provides better results than BigQuery ML.
- dolel22 5y agoYou can train a model with Google Cloud AutoML directly in BigQuery ML, according to this: https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-create-automl https://cloud.google.com/bigquery-ml/docs/reference/standard...
- speedgoose 5y agoThanks for the link, it sounds promising !
- wfriesen 5y agoThis isn't really "in SQL" as much as "using a product that has a SQL extension/backend".
- deleted 5y ago[deleted]
- Hjfrf 5y agoHere's one in actual SQL- https://www.red-gate.com/simple-talk/blogs/statistics-sql-simple-linear-regressions/ https://www.red-gate.com/simple-talk/blogs/statistics-sql-si...
- Simon_O_Rourke 5y agoCheck out the statistical functions baked into Snowflake SQL. We've got a PL/SQL script that forecasts sales volume with seasonality, using a modified ARIMA approach. We're also turning this approach loose on our own data pipeline to trigger alerts on abnormal row counts.
- hackernewds 5y ago
- andix 5y agoYou can do your own forecasting in SQL with Python or R. Depending which database you use, there will probably be some kind of integration. Postgres has PL/R and PL/Python.