Why Use Google BigQuery?
LogosPlatforms
Why use BigQuery?
Cost Effective
Infrastructure MaintenanceDB
Administrators
LogosPlatforms
Why use BigQuery?
Easy Integration
LogosPlatforms
Why use BigQuery?
Easy Integration
LogosPlatforms
Why use BigQuery?
High Speed Processing
Use the processing power of Google's infrastructure to query huge amounts of data in just seconds!
LogosPlatforms
Why use BigQuery?
Limitless Storage Capacity
Utilise the volume of Google’s massive data centres.
How To Use Google BigQuery
LogosPlatforms#1 BigQuery Web UI
• First stop for budding BQ users
• View, manage & query BQ datasets and tables
How To Use Google BigQuery
Examples
to Follow
LogosPlatforms
How To Use Google BigQuery
#2 BigQuery API
• Build custom tools and web apps that interact with BQ
• Implement automated processes to refresh or archive data
LogosPlatforms
How To Use Google BigQuery
Client library project page Reference documentation Download
BigQuery API Client Library for .NET BigQuery .NET doc Download
BigQuery API Client Library for Go BigQuery GoDoc Download
BigQuery API Client Library for Java BigQuery JavaDoc Download
Google API Client Library for JavaScript (beta) N/A N/A
Google API Client Library for Node.js (alpha) N/A Download
Google API Client Library for Objective-C N/A Download
Google API Client Library for PHP (beta) N/A Download
BigQuery API Client Library for Python BigQuery PyDoc Download
Google API Client Library for Ruby (alpha) N/A Download
API Client Libraries
LogosPlatforms
How To Use Google BigQuery
#3 BigQuery Command Line Tool
• Install Google Cloud SDK
• Run queries through the command line tool
LogosPlatforms
SQL Support
Tables can be queried using SQL
LogosPlatforms
SQL Support
BigQuery SQL doesn’t support…
INSERTS
Creating or deleting tables & datasets
LogosPlatforms
Web UI Query Example
Retrieves most popular blogs by # pageviewsSELECT *, COUNT(*) pageviews FROM ( SELECT hits.page.pagePath AS pagePath, MAX(IF(hits.customDimensions.index=1,hits.customDimensions.value,NULL)) WITHIN hits AS Author, MAX(IF(hits.customDimensions.index=2,hits.customDimensions.value,NULL)) WITHIN hits AS Category, FROM TABLE_DATE_RANGE([1690244.ga_sessions_],TIMESTAMP('2015-01-01'),TIMESTAMP('2015-11-02')) WHERE hits.page.pagePath CONTAINS "blog" ) GROUP BY 1, 2, 3 ORDER BY 4 DESC