Skip to content

burnham

baseline

A historical view of pings sent for the burnham/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 burnham/baseline
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_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 burnham_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 burnham_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 burnham_derived baseline_clients_last_seen_v1

Source Directory | Metadata File | View Definition


clients_last_seen_joined

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_derived clients_last_seen_joined_v1

Source Directory | Metadata File | View Definition


deletion_request

A historical view of pings sent for the burnham/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 burnham/deletion-request
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_stable deletion_request_v1

Source Directory | Metadata File | View Definition


discovery

A historical view of pings sent for the burnham/discovery 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 burnham/discovery
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_stable discovery_v1

Source Directory | Metadata File | View Definition


events

A historical view of pings sent for the burnham/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 burnham/events
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_stable events_v1

Source Directory | Metadata File | View Definition


events_unnested

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham events

Source Directory | Metadata File | View Definition


metrics

A historical view of pings sent for the burnham/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 burnham/metrics
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_stable metrics_v1

Source Directory | Metadata File | View Definition


metrics_clients_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_derived metrics_clients_daily_v1

Source Directory | Metadata File | View Definition


metrics_clients_last_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_derived metrics_clients_last_seen_v1

Source Directory | Metadata File | View Definition


space_ship_ready

A historical view of pings sent for the burnham/space-ship-ready 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 burnham/space-ship-ready
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_stable space_ship_ready_v1

Source Directory | Metadata File | View Definition


starbase46

A historical view of pings sent for the burnham/starbase46 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 burnham/starbase46
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod burnham_stable starbase46_v1

Source Directory | Metadata File | View Definition