Big Data & Machine Learning Cloud OnBoard 1 2 1 A demo of BigQuery on a 10 billion-row dataset shows what it is 3 and what it can do 2 5 3 6 5 #standardsql 7 SELECT Familiar, SQL 2011 query 6 language, SUM(views) as views language 8 7 FROM `bigquery-samples.wikipedia_benchmark.Wiki10B` Interactive ad-hoc analysis 9 WHERE of petabyte-scale databases 8 title like "%google%" No need to provision 10 9 GROUP by language clusters 11 ORDER by views DESC 10 12 11 13 12 14 13 15 14 16 15 1716 17 18 Big Data & Machine Learning Cloud OnBoard 1 2 1 Three ways of loading data into BigQuery 3 2 5 3 6 5 Files on disk or Cloud Stream Data Federated data source 7 Storage 6 8 7 9 8 10 9 CSV 11 JSON 10 AVRO 12 11 Google 13 Sheets 12 Serverless POST 14 13 ETL 15 14 16 15 1716 17 18 42

Google Cloud Manual - Page 44 Google Cloud Manual Page 43 Page 45