mozphab

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

Source Directory

baseline

Historical Pings for mozphab/baseline

mozphab.baseline

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

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	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
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	mozphab_stable	baseline_v1

Source Directory | View Definition | Metadata File

baseline_clients_daily

Baseline Clients Daily

mozphab.baseline_clients_daily

A daily aggregate of baseline pings per client_id.

Clustering fields: normalized_channel, sample_id

baseline_clients_first_seen

Baseline Clients First Seen

mozphab.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.

Owners:
- ascholtz@mozilla.com

Schema
Column	Type	Nullable
submission_date	Date	Yes
client_id	String	Yes
sample_id	Integer	Yes
first_run_date	Date	Yes
durations	Integer	Yes
days_seen_session_start_bits	Integer	Yes
days_seen_session_end_bits	Integer	Yes
normalized_channel	String	Yes
normalized_os	String	Yes
normalized_os_version	String	Yes
android_sdk_version	String	Yes
locale	String	Yes
city	String	Yes
country	String	Yes
app_build	String	Yes
app_channel	String	Yes
app_display_version	String	Yes
architecture	String	Yes
device_manufacturer	String	Yes
device_model	String	Yes
telemetry_sdk_build	String	Yes
first_seen_date	Date	Yes
is_new_profile	Boolean	Yes
isp	String	Yes

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

Source Directory | View Definition | Metadata File

baseline_clients_last_seen

Baseline Clients Last Seen

mozphab.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

clients_last_seen_joined

Clients Last Seen Joined

mozphab.clients_last_seen_joined

Please provide a description for the query

Schema
Column	Type	Nullable
submission_date	Date	Yes
normalized_channel	String	Yes
client_id	String	Yes
sample_id	Integer	Yes
days_since_seen	Integer	Yes
days_since_created_profile	Integer	Yes
days_since_seen_session_start	Integer	Yes
days_since_seen_session_end	Integer	Yes
days_seen_bits	Integer	Yes
days_created_profile_bits	Integer	Yes
first_run_date	Date	Yes
durations	Integer	Yes
days_seen_session_start_bits	Integer	Yes
days_seen_session_end_bits	Integer	Yes
normalized_os	String	Yes
normalized_os_version	String	Yes
android_sdk_version	String	Yes
locale	String	Yes
city	String	Yes
country	String	Yes
app_build	String	Yes
app_channel	String	Yes
app_display_version	String	Yes
architecture	String	Yes
device_manufacturer	String	Yes
device_model	String	Yes
telemetry_sdk_build	String	Yes
first_seen_date	Date	Yes
is_new_profile	Boolean	Yes
n_metrics_ping	Integer	Yes
days_sent_metrics_ping_bits	Integer	Yes
isp	String	Yes

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

Source Directory | View Definition | Metadata File

deletion_request

Historical Pings for mozphab/deletion-request

mozphab.deletion_request

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

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	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
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	mozphab_stable	deletion_request_v1

Source Directory | View Definition | Metadata File

events

Historical Pings for mozphab/events

mozphab.events

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

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	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
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	mozphab_stable	events_v1

Source Directory | View Definition | Metadata File

events_unnested

Events Unnested

mozphab.events_unnested

Please provide a description for the query

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

Source Directory | View Definition | Metadata File

metrics

Historical Pings for mozphab/metrics

mozphab.metrics

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

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	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
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	mozphab_stable	metrics_v1

Source Directory | View Definition | Metadata File

metrics_clients_daily

Metrics Clients Daily

mozphab.metrics_clients_daily

Please provide a description for the query

Schema
Column	Type	Nullable
submission_date	Date	Yes
client_id	String	Yes
sample_id	Integer	Yes
normalized_channel	String	Yes
n_metrics_ping	Integer	Yes
days_sent_metrics_ping_bits	Integer	Yes

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

Source Directory | View Definition | Metadata File

metrics_clients_last_seen

Metrics Clients Last Seen

mozphab.metrics_clients_last_seen

Please provide a description for the query

Schema
Column	Type	Nullable
submission_date	Date	Yes
client_id	String	Yes
sample_id	Integer	Yes
normalized_channel	String	Yes
n_metrics_ping	Integer	Yes
days_sent_metrics_ping_bits	Integer	Yes

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

Source Directory | View Definition | Metadata File

usage

Historical Pings for mozphab/usage

mozphab.usage

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

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	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
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	mozphab_stable	usage_v1

Source Directory | View Definition | Metadata File