mozdata

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

Source Directory

event

Historical Pings for mozdata/event

mozdata.event

A historical view of pings sent for the mozdata/event 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
ad_hoc_tables_dir		String	Yes
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
api_call		String	Yes
api_version		String	Yes
detected_uri		String	Yes
detected_version		String	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
metadata		Record	Yes
name		String	Yes
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
owner		String	Yes
partition		String	Yes
query		String	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
sources_json		String	Yes
sql_table_name		String	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes
table_name		String	Yes
uri		String	Yes
version		String	Yes

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	mozdata_stable	event_v1

Source Directory | View Definition | Metadata File

---