Database Reference
In-Depth Information
by anyone with a BigQuery account. You likely will want to lock down your
data more tightly, but for the purposes of the topic, we wanted to make the
underlying data as available asx possible.
To access these tables, you can open the BigQuery web UI at
https://bigquery.cloud.google.com
and select Switch to project
Display project from the project menu on the left tab. Then enter
bigquery-e2e
as the project ID. The datasets used by the End-to-End
application display on the left panel. Chapter 3, “Getting Started with
BigQuery,” has more information about setting up your account for using
BigQuery, so if it isn't clear how to start, detailed instructions are on the way.
Figure 2.2
, earlier in the chapter, shows what the web UI looks like.
As you work through the examples in the topic, it may be useful to browse
these tables; look at their schemas, look at the contents, and run a couple
of sample queries on them. Note that running queries costs money if you
go above the “free” 1 TB per month quota. All the examples in this topic
should use relatively small data sizes to keep you under the 1 TB cap, but
you should know that after you exceed that limit, you're on your own for any
query charges that are incurred.
Summary
This chapter introduced BigQuery and walked through the various
components of the service: the query engine, the cloud-based data
warehouse, and the HTTP API.
The chapter also evaluated BigQuery for prospective customers by
describing the types of problems it is good for and the types of problems it
isn't good for. We compared it to other Big Data systems such as Hadoop
and NoSQL databases.
This chapter also discussed the technology that BigQuery is built on top
of, such as Dremel, Colossus, and Megastore, which may be interesting
to those who follow Google's technology disclosures. It mapped out the
various components of the Google Cloud Platform and described how they
interoperate with BigQuery.
Finally, this chapter introduced the Android app and Sensors AppEngine
application that are the basis for the examples in this topic, and whose
