Time Series Forecasting in SQL(aicoding.substack.com)
aicoding.substack.com
Time Series Forecasting in SQL
https://aicoding.substack.com/p/mindsdb-time-series
10 comments
This isn't really "in SQL" as much as "using a product that has a SQL extension/backend".
Here's one in actual SQL-
https://www.red-gate.com/simple-talk/blogs/statistics-sql-si...
https://www.red-gate.com/simple-talk/blogs/statistics-sql-si...
[deleted]
You 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.
I 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.
You can train a model with Google Cloud AutoML directly in BigQuery ML, according to this: https://cloud.google.com/bigquery-ml/docs/reference/standard...
Thanks for the link, it sounds promising !
Check 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.