Skip to content

mozilla_mach

baseline

A historical view of pings sent for the mozilla-mach/baseline 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

  • Friendly name: Historical Pings for mozilla-mach/baseline
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_stable baseline_v1

Source Directory | Metadata File | View Definition


baseline_clients_daily

A daily aggregate of baseline pings per client_id.

Clustering fields: normalized_channel, sample_id

See also: baseline_clients_last_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_derived baseline_clients_daily_v1

Source Directory | Metadata File | View Definition


baseline_clients_first_seen

Captures the earliest server date that we observe a particular client in the baseline table. A client may have a first_seen_date that is earlier than the epoch of the baseline table; this is the result of a migration from a legacy data collection system. These clients are therefore not captured in this table.

Clustering fields: sample_id

See also: baseline_clients_daily and baseline_clients_last_seen.

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_derived baseline_clients_daily_v1

Source Directory | Metadata File | View Definition


baseline_clients_last_seen

Captures activity history of each client in 28-day windows for each submission date based on baseline pings.

Clustering fields: normalized_channel, sample_id

See also: baseline_clients_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_derived baseline_clients_last_seen_v1

Source Directory | Metadata File | View Definition


deletion_request

A historical view of pings sent for the mozilla-mach/deletion-request 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

  • Friendly name: Historical Pings for mozilla-mach/deletion-request
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_stable deletion_request_v1

Source Directory | Metadata File | View Definition


events

A historical view of pings sent for the mozilla-mach/events 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

  • Friendly name: Historical Pings for mozilla-mach/events
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_stable events_v1

Source Directory | Metadata File | View Definition


metrics

A historical view of pings sent for the mozilla-mach/metrics 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

  • Friendly name: Historical Pings for mozilla-mach/metrics
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_stable metrics_v1

Source Directory | Metadata File | View Definition


usage

A historical view of pings sent for the mozilla-mach/usage 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

  • Friendly name: Historical Pings for mozilla-mach/usage
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_mach_stable usage_v1

Source Directory | Metadata File | View Definition