Data Warehouse

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

Materialize the query result for multistage queries to make your query faster and lower the costs.