Meta tables are very useful when it comes to get bigquery table information programmatically.
Snippet for calculating moving avg using sql/biguqery
Generate a table with a column of continuous dates
BigQuery Current User
Materialize the query result for multistage queries to make your query faster and lower the costs.