Skip to content

Instantly share code, notes, and snippets.

@relud

relud/decoded.bqschema.json

Last active August 1, 2019 19:27
Show Gist options
  • Save relud/453b96ee5795764a271ce048f0a7a9e3 to your computer and use it in GitHub Desktop.
Save relud/453b96ee5795764a271ce048f0a7a9e3 to your computer and use it in GitHub Desktop.
Download ZIP
non-payload-format bigquery schemas
Raw
decoded.bqschema.json
[
{
"fields": [
{
"mode": "NULLABLE",
"name": "document_namespace",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "document_type",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "document_version",
"type": "STRING"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "city",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "country",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "subdivsion1",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "subdivision2",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "geo",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "date",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "dnt",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_debug_id",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_pingsender_version",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "header",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "app_build_id",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "app_name",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "app_update_channel",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "app_version",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "uri",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "browser",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "browser_version",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "os",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "os_version",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "user_agent",
"type": "RECORD"
}
],
"mode": "NULLABLE",
"name": "metadata",
"type": "RECORD"
},
{
"mode": "NULLABLE",
"name": "normalized_app_name",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "normalized_channel",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "normalized_country_code",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "normalized_os",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "normalized_os_version",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "payload",
"type": "BYTES"
},
{
"mode": "NULLABLE",
"name": "sample_id",
"type": "INTEGER"
},
{
"mode": "REQUIRED",
"name": "submission_timestamp",
"type": "TIMESTAMP"
}
]
Raw
error.bqschema.json
[
{
"mode": "NULLABLE",
"name": "args",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "content_length",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "date",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "dnt",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "error_message",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "error_type",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "exception_class",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "host",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "method",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "payload",
"type": "BYTES"
},
{
"mode": "NULLABLE",
"name": "protocol",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "remote_addr",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "stack_trace",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "stack_trace_cause_1",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "stack_trace_cause_2",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "stack_trace_cause_3",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "stack_trace_cause_4",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "stack_trace_cause_5",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "submission_timestamp",
"type": "TIMESTAMP"
},
{
"mode": "NULLABLE",
"name": "uri",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "user_agent",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_debug_id",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_forwarded_for",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_pingsender_version",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_pipeline_proxy",
"type": "STRING"
}
]
Raw
raw.bqschema.json
[
{
"mode": "NULLABLE",
"name": "args",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "content_length",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "date",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "dnt",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "host",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "method",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "payload",
"type": "BYTES"
},
{
"mode": "NULLABLE",
"name": "protocol",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "remote_addr",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "submission_timestamp",
"type": "TIMESTAMP"
},
{
"mode": "NULLABLE",
"name": "uri",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "user_agent",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_debug_id",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_forwarded_for",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_pingsender_version",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "x_pipeline_proxy",
"type": "STRING"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment