Data Warehouse

The Three Key Ideas about Warehouse The purpose of the data warehouse should be clear. In most …

ETL Process ETL ETL Extract: extract data from sources Transform: transform it to proper format …

tl;dr: Use type safe formats such as HDF5 or parquet HDF5 BCOLZ …

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.