BigQuery

History

• announced in May 2010 at Google I/O
• GA in 2012

Compete with Redshift

Both ETL & ELT strategies can be used very effectively with BigQuery as the primary & final destination data store and GCS as the staging (or ingest) or intermediate data store as required.

Denormalize Design: BigQuery is designed to store one large denormalized table.

• less Join
• No primary key, unique key or index column

Based on Google's internal Dremel query engine

• enabled quick queries across trillions of rows of data