Skip to content

Firefox Ios

Views on data from firefox_ios

Source Directory

baseline

App-specific view for Glean ping "baseline"

firefox_ios.baseline

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.baseline).

It is used by Looker.

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 org_mozilla_ios_firefox baseline

Source Directory | View Definition | Metadata File


baseline_clients_daily

firefox_ios.baseline_clients_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_ios_firefox baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta baseline_clients_daily

Source Directory | View Definition | Metadata File


baseline_clients_first_seen

firefox_ios.baseline_clients_first_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_ios_firefox baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta baseline_clients_first_seen

Source Directory | View Definition | Metadata File


baseline_clients_last_seen

firefox_ios.baseline_clients_last_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_firefox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta baseline_clients_last_seen

Source Directory | View Definition | Metadata File


clients_last_seen_joined

firefox_ios.clients_last_seen_joined

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
uri_count Integer Yes
is_default_browser Boolean Yes
isp String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod firefox_ios_derived clients_last_seen_joined_v1

Source Directory | View Definition | Metadata File


deletion_request

App-specific view for Glean ping "deletion-request"

firefox_ios.deletion_request

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.deletion_request).

It is used by Looker.

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 org_mozilla_ios_firefox deletion_request

Source Directory | View Definition | Metadata File


events

App-specific view for Glean ping "events"

firefox_ios.events

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.events).

It is used by Looker.

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 org_mozilla_ios_firefox events

Source Directory | View Definition | Metadata File


events_unnested

firefox_ios.events_unnested

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec events
moz-fx-data-shared-prod org_mozilla_ios_firefox events
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta events

Source Directory | View Definition | Metadata File


first_session

App-specific view for Glean ping "first-session"

firefox_ios.first_session

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.first_session).

It is used by Looker.

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 org_mozilla_ios_firefox first_session

Source Directory | View Definition | Metadata File


metrics

App-specific view for Glean ping "metrics"

firefox_ios.metrics

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.metrics).

It is used by Looker.

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 org_mozilla_ios_firefox metrics

Source Directory | View Definition | Metadata File


metrics_clients_daily

firefox_ios.metrics_clients_daily

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
uri_count Integer Yes
is_default_browser Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod firefox_ios_derived metrics_clients_daily_v1

Source Directory | View Definition | Metadata File


metrics_clients_last_seen

firefox_ios.metrics_clients_last_seen

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
uri_count Integer Yes
is_default_browser Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod firefox_ios_derived metrics_clients_last_seen_v1

Source Directory | View Definition | Metadata File


temp_bookmarks_sync

App-specific view for Glean ping "temp-bookmarks-sync"

firefox_ios.temp_bookmarks_sync

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_bookmarks_sync).

It is used by Looker.

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 org_mozilla_ios_firefox temp_bookmarks_sync

Source Directory | View Definition | Metadata File


temp_clients_sync

App-specific view for Glean ping "temp-clients-sync"

firefox_ios.temp_clients_sync

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_clients_sync).

It is used by Looker.

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 org_mozilla_ios_firefox temp_clients_sync

Source Directory | View Definition | Metadata File


temp_history_sync

App-specific view for Glean ping "temp-history-sync"

firefox_ios.temp_history_sync

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_history_sync).

It is used by Looker.

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 org_mozilla_ios_firefox temp_history_sync

Source Directory | View Definition | Metadata File


temp_logins_sync

App-specific view for Glean ping "temp-logins-sync"

firefox_ios.temp_logins_sync

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_logins_sync).

It is used by Looker.

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 org_mozilla_ios_firefox temp_logins_sync

Source Directory | View Definition | Metadata File


temp_rust_tabs_sync

App-specific view for Glean ping "temp-rust-tabs-sync"

firefox_ios.temp_rust_tabs_sync

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_rust_tabs_sync).

It is used by Looker.

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 org_mozilla_ios_firefox temp_rust_tabs_sync

Source Directory | View Definition | Metadata File


temp_sync

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

firefox_ios.temp_sync

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_sync).

It is used by Looker.

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 org_mozilla_ios_firefox temp_sync

Source Directory | View Definition | Metadata File


temp_tabs_sync

App-specific view for Glean ping "temp-tabs-sync"

firefox_ios.temp_tabs_sync

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_tabs_sync).

It is used by Looker.

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 org_mozilla_ios_firefox temp_tabs_sync

Source Directory | View Definition | Metadata File


topsites_impression

App-specific view for Glean ping "topsites-impression"

firefox_ios.topsites_impression

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.topsites_impression).

It is used by Looker.

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 org_mozilla_ios_firefox topsites_impression

Source Directory | View Definition | Metadata File