mozillavpn

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

Source Directory

baseline

Historical Pings for mozillavpn/baseline

mozillavpn.baseline

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

Source Directory | View Definition | Metadata File

baseline_clients_daily

Baseline Clients Daily

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

mozillavpn.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	mozillavpn_derived	baseline_clients_daily_v1

Source Directory | View Definition | Metadata File

baseline_clients_last_seen

Baseline Clients Last Seen

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

daemonsession

Historical Pings for mozillavpn/daemonsession

mozillavpn.daemonsession

A historical view of pings sent for the mozillavpn/daemonsession 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	mozillavpn_stable	daemonsession_v1

Source Directory | View Definition | Metadata File

deletion_request

Historical Pings for mozillavpn/deletion-request

mozillavpn.deletion_request

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

Source Directory | View Definition | Metadata File

events

Historical Pings for mozillavpn/events

mozillavpn.events

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

Source Directory | View Definition | Metadata File

main

Historical Pings for mozillavpn/main

mozillavpn.main

A historical view of pings sent for the mozillavpn/main 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	mozillavpn_stable	main_v1

Source Directory | View Definition | Metadata File

metrics

Historical Pings for mozillavpn/metrics

mozillavpn.metrics

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

Source Directory | View Definition | Metadata File

vpnsession

Historical Pings for mozillavpn/vpnsession

mozillavpn.vpnsession

A historical view of pings sent for the mozillavpn/vpnsession 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	mozillavpn_stable	vpnsession_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