firefox-desktop-background-tasks

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

Source Directory

background_tasks

Historical Pings for firefox-desktop-background-tasks/background-tasks

firefox_desktop_background_tasks.background_tasks

A historical view of pings sent for the firefox-desktop-background-tasks/background-tasks 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	firefox_desktop_background_tasks_stable	background_tasks_v1

Source Directory | View Definition | Metadata File

baseline

Historical Pings for firefox-desktop-background-tasks/baseline

firefox_desktop_background_tasks.baseline

A historical view of pings sent for the firefox-desktop-background-tasks/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	firefox_desktop_background_tasks_stable	baseline_v1

Source Directory | View Definition | Metadata File

baseline_clients_daily

Baseline Clients Daily

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

firefox_desktop_background_tasks.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
isp	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

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

Source Directory | View Definition | Metadata File

baseline_clients_last_seen

Baseline Clients Last Seen

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

crash

Historical Pings for firefox-desktop-background-tasks/crash

firefox_desktop_background_tasks.crash

A historical view of pings sent for the firefox-desktop-background-tasks/crash 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	firefox_desktop_background_tasks_stable	crash_v1

Source Directory | View Definition | Metadata File

default_agent

Historical Pings for firefox-desktop-background-tasks/default-agent

firefox_desktop_background_tasks.default_agent

A historical view of pings sent for the firefox-desktop-background-tasks/default-agent 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	firefox_desktop_background_tasks_stable	default_agent_v1

Source Directory | View Definition | Metadata File

deletion_request

Historical Pings for firefox-desktop-background-tasks/deletion-request

firefox_desktop_background_tasks.deletion_request

A historical view of pings sent for the firefox-desktop-background-tasks/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	firefox_desktop_background_tasks_stable	deletion_request_v1

Source Directory | View Definition | Metadata File

events

Historical Pings for firefox-desktop-background-tasks/events

firefox_desktop_background_tasks.events

A historical view of pings sent for the firefox-desktop-background-tasks/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	firefox_desktop_background_tasks_stable	events_v1

Source Directory | View Definition | Metadata File

events_unnested

Events Unnested

firefox_desktop_background_tasks.events_unnested

Please provide a description for the query

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

Source Directory | View Definition | Metadata File

metrics

Historical Pings for firefox-desktop-background-tasks/metrics

firefox_desktop_background_tasks.metrics

A historical view of pings sent for the firefox-desktop-background-tasks/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	firefox_desktop_background_tasks_stable	metrics_v1

Source Directory | View Definition | Metadata File

metrics_clients_daily

Metrics Clients Daily

firefox_desktop_background_tasks.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	firefox_desktop_background_tasks_derived	metrics_clients_daily_v1

Source Directory | View Definition | Metadata File

Column	Type	Nullable
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
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
isp	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