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