Database Reference
In-Depth Information
Table 14.2
Fields in the GCS Usage Records
Field
Description
Type
Time (microseconds since the Unix
epoch) the request was completed
Integer
time_micros
IP address of client
String
c_ip
IP address type: 1=IPV4, 2=IPV6
String
c_ip_type
Currently not supplied
String
c_ip_region
HTTP request method
String
cs_method
Request path (does not include the host) String
cs_uri
HTTP status code returned to client
Integer
sc_status
Request bytes
Integer
cs_bytes
Response bytes
Integer
sc_bytes
time_taken_micros
Time (microseconds) taken to process the
request
Integer
HTTP request host
String
cs_host
HTTP referrer header value, if present
String
cs_referer
HTTP user agent header value, if present String
cs_user_agent
Server assigned request ID
String
s_request_id
GCS operation performed
String
cs_operation
Target bucket
String
cs_bucket
Target object
String
cs_object
Because the usage log is CSV formatted, it is immediately compatible with
BigQuery, so you can load the data into a BigQuery table with a suitable
schema. GCS provides a reference schema that you can download.
gsutil cp gs://pub/cloud_storage_usage_schema_v0.json
/tmp/
If you prefer to use different names for the fields, you can modify the field
names in the downloaded schema; the command to load the data will still
