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 43 Page 45