Skip to content

Firefox Reality

Views on data from firefox_reality

Source Directory

addresses_sync

App-specific view for Glean ping "addresses-sync"

firefox_reality.addresses_sync

This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.addresses_sync).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.baseline).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_vrbrowser baseline

Source Directory | View Definition | Metadata File


baseline_clients_daily

Baseline Clients Daily

firefox_reality.baseline_clients_daily

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_vrbrowser baseline_clients_daily

Source Directory | View Definition | Metadata File


baseline_clients_first_seen

Baseline Clients First Seen

firefox_reality.baseline_clients_first_seen

Please provide a description for the query

Referenced Tables
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

Baseline Clients Last Seen

firefox_reality.baseline_clients_last_seen

Please provide a description for the query

Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.bookmarks_sync).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_vrbrowser bookmarks_sync

Source Directory | View Definition | Metadata File


clients_last_seen_joined

Clients Last Seen Joined

firefox_reality.clients_last_seen_joined

Please provide a description for the query

Schema
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
normalized_app_id String Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.creditcards_sync).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.deletion_request).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.events).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_vrbrowser events

Source Directory | View Definition | Metadata File


events_unnested

Events Unnested

firefox_reality.events_unnested

Please provide a description for the query

Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.history_sync).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.logins_sync).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.metrics).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_vrbrowser metrics

Source Directory | View Definition | Metadata File


metrics_clients_daily

Metrics Clients Daily

firefox_reality.metrics_clients_daily

Please provide a description for the query

Schema
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
Referenced Tables
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

Metrics Clients Last Seen

firefox_reality.metrics_clients_last_seen

Please provide a description for the query

Schema
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
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.session_end).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.sync).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox Reality" (org_mozilla_vrbrowser.tabs_sync).

It is used by Looker.

Schema
Column Description Type Nullable
normalized_app_id App ID of the channel data was received from String Yes
normalized_channel Normalized channel name String Yes
additional_properties String Yes
client_info Record Yes
document_id String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_vrbrowser tabs_sync

Source Directory | View Definition | Metadata File