Skip to content

webpagetest

User-facing views related to document namespace webpagetest; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/webpagetest

Source Directory

webpagetest_run

Historical Pings for webpagetest/webpagetest-run

webpagetest.webpagetest_run

A historical view of pings sent for the webpagetest/webpagetest-run document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
app_name String Yes
channel String Yes
connection String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
metrics Record No
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
platform String Yes
run_id String Yes
runner String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
session_state String Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
url String Yes
version String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod webpagetest_stable webpagetest_run_v1

Source Directory | View Definition | Metadata File