Database Reference
In-Depth Information
Querying the Data
The first thing to try is to look at the schema of the destination table, as
shown in
Listing 11.3
.
Listing 11.3
Schema of the table generated from a Datastore
backup
$
bq show ch11.devices
Table 317752944021:ch11.devices
Last modified Schema
Total Rows Total>
----------------- ---------------------------------
------------ ------>
12 Nov 00:34:16 |- added: integer
3 567
|- os: string
|- make: string
|- home_zip5: string
|- os_version: string
|- carrier: string
+- owner: record
| |- email: string
| |- userid: integer
|- model: string
|- type: string
+- screen: record
| |- diagonal: float
| |- res_x: integer
| |- res_y: integer
| +- __key__: record
| | |- namespace: string
| | |- app: string
| | |- path: string
| | |- kind: string
| | |- name: string
| | |- id: integer
|- storage_gb: integer
