Big Data & Machine Learning Cloud OnBoard 1 2 1 With Federated data sources, you can directly query files on 3 Cloud Storage, without having to ingest them into BigQuery 2 5 3 6 5 7 6 8 7 Also: Google Drive, Bigtable 9 8 10 Also: JSON/Avro/Google Sheet 9 11 10 12 11 13 12 14 Can also pass in a schema 13 15 14 16 15 1716 17 18 Big Data & Machine Learning Cloud OnBoard 1 2 1 Comparing storage options: technical details 3 2 5 3 6 Cloud Cloud Cloud 5 Bigtable Cloud SQL BigQuery 7 Datastore Storage Spanner 6 8 7 Type NoSQL NoSQL Blobstore Relational Relational Relational 9 document wide column SQL for OLTP SQL for OLTP SQL for OLAP 8 10 9 Transactions Yes Single-row No Yes Yes No 11 10 12 Complex No No No Yes Yes Yes 11 queries 13 12 14 Capacity Terabytes+ Petabytes+ Petabytes+ 500 GB Petabytes Petabytes+ 13 15 14 Unit size 1 MB/entity ~10 MB/cell 5 TB/object Determined 10,240 MiB/ 10 MB/row 16 ~100 MB/row by DB engine row 15 1716 17 18 43