Database Reference
In-Depth Information
information. Still, if you have concerns, you should definitely consider
building your own version of the application and logging to your private
instance for experimenting with this sample application.
The last part of the application is a dashboard that summarizes the logs
being received by the application. Although the first two parts described
dealt with getting data into BigQuery, this part deals with extracting and
rendering a useful summary of the data. The dashboard is again built on
Google
App
Engine
and
is
available
at:
https://bigquery-sensors.appspot.com/console .
The page consists of a collection of graphs and tables that provide an
aggregated view of the state of the phones registered with the service. Of
course, aggregated information is interesting, but a key strength of BigQuery
is the capability to perform interactive queries over a large number of
records without any pre-aggregation. To highlight this capability, the
application generates reports for individual phones registered under your
account. You can navigate to these records from the device management
page previously mentioned by clicking the device ID for the registered
device. This takes you to a page with a summary of the records associated
with that device.
Git Repository
The source for the sample application is included in the download for
this chapter. However, we expect it to evolve over time, so we have also
made it available as an online repository at
https://code.google.com/p/bigquery-e2e/ .
You can download the latest version from the site as a zip file, or if you
have git installed, you can check out the source code.
$ GOOGLE_USER='<your Google username>'
$ git clone https:/${GOOGLE_USER}@code.google.com/p/
bigquery-e2e/
We would be happy to receive patches!
Search WWH ::




Custom Search