3.16 SQL at scale: Google BigQuery

• GBQ one of many commercial SQL databases available (Amazon RedShift, Microsoft Azure, Oracle Live SQL…)
• Used by many financial and commercial companies
• Advantages:
  • Integration with other Google Cloud products (Google Drive, Google Cloud Storage, Google Cloud ML products)
  • Scalable: same SQL (or R) syntax for datasets of any size
  • Easy to collaborate and export results
  • Affordable pricing and cost control
  • API access allows integration with R or python
  • Good documentation