Calculate Moving Average Using SQL/BigQquery

GROWING This note is being developed. It is readible but changes are being applied.
til/data/bigquery-moving-average.md Current Note ID: The unique ID of this note.
#Data Warehouse #Big Query #SQL

Snippet for calculating moving avg using sql/biguqery

Calculate moving avg using sql/biguqery

AVG(users) OVER (ORDER BY day ROWS BETWEEN 6 PRECEDING AND 0 FOLLOWING) AS moving_avg

What about moving average for different categories? For example, we have date, categories, fee. We would like to calculate the moving avg for each category.

Planted: by ;

References:
  1. Getting table metadata using INFORMATION_SCHEMA
Similar Articles:
BigQuery Meta Tables
Meta tables are very useful when it comes to get bigquery table information programmatically.
Generate a Column of Continuous Dates in BigQuery
Generate a table with a column of continuous dates
Get Current User in BigQuery
BigQuery Current User
Materialize the Query Result for Performance
Materialize the query result for multistage queries to make your query faster and lower the costs.

Lei Ma (2019). 'Calculate Moving Average Using SQL/BigQquery', Datumorphism, 05 April. Available at: https://datumorphism.leima.is/til/data/bigquery-moving-average/.