Firefox Reality
Views on data from firefox_reality
addresses_sync
App-specific view for Glean ping "addresses-sync"
firefox_reality.addresses_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.addresses_sync).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | addresses_sync |
Source Directory | View Definition | Metadata File
baseline
App-specific view for Glean ping "baseline"
firefox_reality.baseline
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.baseline).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | baseline |
Source Directory | View Definition | Metadata File
baseline_clients_daily
firefox_reality.baseline_clients_daily
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | baseline_clients_daily |
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
firefox_reality.baseline_clients_first_seen
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | baseline_clients_first_seen |
Source Directory | View Definition | Metadata File
baseline_clients_last_seen
firefox_reality.baseline_clients_last_seen
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | baseline_clients_last_seen |
Source Directory | View Definition | Metadata File
bookmarks_sync
App-specific view for Glean ping "bookmarks-sync"
firefox_reality.bookmarks_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.bookmarks_sync).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | bookmarks_sync |
Source Directory | View Definition | Metadata File
clients_last_seen_joined
firefox_reality.clients_last_seen_joined
Column | Description | 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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | firefox_reality_derived | clients_last_seen_joined_v1 |
Source Directory | View Definition | Metadata File
creditcards_sync
App-specific view for Glean ping "creditcards-sync"
firefox_reality.creditcards_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.creditcards_sync).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | creditcards_sync |
Source Directory | View Definition | Metadata File
deletion_request
App-specific view for Glean ping "deletion-request"
firefox_reality.deletion_request
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.deletion_request).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | deletion_request |
Source Directory | View Definition | Metadata File
events
App-specific view for Glean ping "events"
firefox_reality.events
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.events).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | events |
Source Directory | View Definition | Metadata File
events_unnested
firefox_reality.events_unnested
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | events |
Source Directory | View Definition | Metadata File
history_sync
App-specific view for Glean ping "history-sync"
firefox_reality.history_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.history_sync).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | history_sync |
Source Directory | View Definition | Metadata File
logins_sync
App-specific view for Glean ping "logins-sync"
firefox_reality.logins_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.logins_sync).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | logins_sync |
Source Directory | View Definition | Metadata File
metrics
App-specific view for Glean ping "metrics"
firefox_reality.metrics
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.metrics).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | metrics |
Source Directory | View Definition | Metadata File
metrics_clients_daily
firefox_reality.metrics_clients_daily
Column | Description | 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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | firefox_reality_derived | metrics_clients_daily_v1 |
Source Directory | View Definition | Metadata File
metrics_clients_last_seen
firefox_reality.metrics_clients_last_seen
Column | Description | 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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | firefox_reality_derived | metrics_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
session_end
App-specific view for Glean ping "session-end"
firefox_reality.session_end
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.session_end).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | session_end |
Source Directory | View Definition | Metadata File
sync
App-specific view for Glean ping "sync"
firefox_reality.sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.sync).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | sync |
Source Directory | View Definition | Metadata File
tabs_sync
App-specific view for Glean ping "tabs-sync"
firefox_reality.tabs_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox Reality" (moz-fx-data-shared-prod.org_mozilla_vrbrowser.tabs_sync).
It is used by Looker.
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 |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_vrbrowser | tabs_sync |
Source Directory | View Definition | Metadata File