Database Reference
In-Depth Information
Table 4.2
Sensor Data Schema (Abridged)
Field
Type
Description
ID of the device recording its
data
id
STRING
(REQUIRED)
Time the sensor data was
recorded
time
TIMESTAMP
(REQUIRED)
Whether the device screen was
on
screen_on
BOOLEAN
Memory usage and capacity
information
memory
RECORD
Amount of memory on the
device, in bytes
memory.avaiable
INTEGER
Amount of memory currently
in use, in bytes
memory.used
INTEGER
Record containing running
application information on the
device
running
REPEATED
RECORD
Name of the running app
running.name
STRING
Information about memory
used by the app
running.memory
RECORD
Total amount of memory used
by the app, in bytes
running.memory.total INTEGER
This table will be referenced throughout the topic; you'll see how it gets
created in Chapter 8.
Summary
This chapter discussed the principal abstractions used by BigQuery:
projects, datasets, tables, schemas, and jobs. This chapter talked about the
relationships among these objects, how they are used, and how access to
them can be controlled. Understanding these abstractions is important
when using BigQuery, and it may be helpful to refer back to this chapter if
something about these objects doesn't make sense. We also introduced the
