BigQuery

FOR LARGE DATA SETS

REALLY LARGE

REALLY REALLY LARGE

REST API

maximum

1MB/row

maximum

10MB/request

500 rows/request recommended

Cloud Storage

by job

1000 jobs/table daily

50K jobs/project daily

2MB/row

4GB compressed

5TB uncompressed

Query​

Legacy vs. Standard SQL

Legacy IS faster

Standard has some cool features

You can write your own functions in JavaScript 🙃