Database Reference
In-Depth Information
Table 4.1
BigQuery Object Names
Object
Type
Reference Components
Fully Qualified Identifiers
Project
projectId: bigquery-e2e bigquery-e2e
Project
(Google
Apps for
Your
Domain)
projectId:
google.com
:
bigquery-e2e
google.com
:bigquery-e2e
Dataset
projectId: bigquery-e2e
datasetId: logs
bigquery-e2e:logs
Dataset
(Google
Apps for
Your
Domain)
google.com
:bigquery-e2e:logs
Table
projectId: bigquery-e2e
datasetId: logs
tableId: latest
bigquery-e2e:logs.latest
Job
projectId: bigquery-e2e
job_id: job-abcdefg0001
bigquery-e2e:job-abcdefg0001
Schemas
BigQuery schemas control what type of data the tables are allowed to
contain. Schemas contain zero or more
fields
, which are strongly typed
columns of values. The primitive field types are
INTEGER
,
FLOAT
,
BOOLEAN
,
STRING
, and
TIMESTAMP
.
INTEGER
values are all signed, 64-bit values.
FLOATs
are IEEE 754 double-precision values.
BOOLEANs
are simple flags;
they can be either
true
or
false
.
STRINGs
are UTF8-encoded string
values. If you want to query over binary data, you should base64-encode
it first (or hex-encode it for easier querying).
TIMESTAMPs
are
microsecond-resolution UTC timestamps.
Figure 4.4
shows a table with a
simple, flat schema.