Database Reference
In-Depth Information
Figure 14.1
Google Analytics sample data
This schema is a great example of leveraging BigQuery's capability to
represent nested and repeated structures in a record. To help understand
the schema, it is useful to look at a stripped down version that highlights
the most important properties and nested structures. We have used italics
to indicate fields that are records containing nested fields and boldface to
indicate fields that are repeated. Note that we have fields that are bold and
italic to indicate that they are repeated records, and we have repeated fields
that appear within a repeated field.
•
visitorId
•
date
•
totals
•
trafficSource
•
device
•
customDimensions
•
hits
•
time
•
referrer
•
page
