org-mozilla-fennec-aurora
User-facing views related to document namespace org-mozilla-fennec-aurora; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/org-mozilla-fennec-aurora
activation
Historical Pings for org-mozilla-fennec-aurora/activation
org_mozilla_fennec_aurora.activation
A historical view of pings sent for the
org-mozilla-fennec-aurora/activation
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
| 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_fennec_aurora_stable | activation_v1 |
Source Directory | View Definition | Metadata File
addresses_sync
Historical Pings for org-mozilla-fennec-aurora/addresses-sync
org_mozilla_fennec_aurora.addresses_sync
A historical view of pings sent for the
org-mozilla-fennec-aurora/addresses-sync
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
| 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_fennec_aurora_stable | addresses_sync_v1 |
Source Directory | View Definition | Metadata File
baseline
Historical Pings for org-mozilla-fennec-aurora/baseline
org_mozilla_fennec_aurora.baseline
A historical view of pings sent for the
org-mozilla-fennec-aurora/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
| 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_fennec_aurora_stable | baseline_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_daily
Baseline Clients Daily
org_mozilla_fennec_aurora.baseline_clients_daily
A daily aggregate of baseline pings per client_id.
Clustering fields: normalized_channel, sample_id
See also: baseline_clients_last_seen
- Owners:
| Column | Description | 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 | |
| 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 | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_fennec_aurora_derived | baseline_clients_daily_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
Baseline Clients First Seen
org_mozilla_fennec_aurora.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:
| Column | Description | 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 | |
| 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 | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_fennec_aurora_derived | baseline_clients_daily_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_last_seen
Baseline Clients Last Seen
org_mozilla_fennec_aurora.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
See also: baseline_clients_daily
- Owners:
| Column | Description | 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 | |
| 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 | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_fennec_aurora_derived | baseline_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
bookmarks_sync
Historical Pings for org-mozilla-fennec-aurora/bookmarks-sync
org_mozilla_fennec_aurora.bookmarks_sync
A historical view of pings sent for the
org-mozilla-fennec-aurora/bookmarks-sync
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
| 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_fennec_aurora_stable | bookmarks_sync_v1 |
Source Directory | View Definition | Metadata File
broken_site_report
Historical Pings for org-mozilla-fennec-aurora/broken-site-report
org_mozilla_fennec_aurora.broken_site_report
A historical view of pings sent for the
org-mozilla-fennec-aurora/broken-site-report
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
| 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_fennec_aurora_stable | broken_site_report_v1 |
Source Directory | View Definition | Metadata File
client_deduplication
Historical Pings for org-mozilla-fennec-aurora/client-deduplication
org_mozilla_fennec_aurora.client_deduplication
A historical view of pings sent for the
org-mozilla-fennec-aurora/client-deduplication
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
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_fennec_aurora_stable | client_deduplication_v1 |
Source Directory | View Definition | Metadata File
cookie_banner_report_site
Historical Pings for org-mozilla-fennec-aurora/cookie-banner-report-site
org_mozilla_fennec_aurora.cookie_banner_report_site
A historical view of pings sent for the
org-mozilla-fennec-aurora/cookie-banner-report-site
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
| 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_fennec_aurora_stable | cookie_banner_report_site_v1 |
Source Directory | View Definition | Metadata File
crash
Historical Pings for org-mozilla-fennec-aurora/crash
org_mozilla_fennec_aurora.crash
A historical view of pings sent for the
org-mozilla-fennec-aurora/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
| 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_fennec_aurora_stable | crash_v1 |
Source Directory | View Definition | Metadata File
creditcards_sync
Historical Pings for org-mozilla-fennec-aurora/creditcards-sync
org_mozilla_fennec_aurora.creditcards_sync
A historical view of pings sent for the
org-mozilla-fennec-aurora/creditcards-sync
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
| 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_fennec_aurora_stable | creditcards_sync_v1 |
Source Directory | View Definition | Metadata File
deletion_request
Historical Pings for org-mozilla-fennec-aurora/deletion-request
org_mozilla_fennec_aurora.deletion_request
A historical view of pings sent for the
org-mozilla-fennec-aurora/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
| 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_fennec_aurora_stable | deletion_request_v1 |
Source Directory | View Definition | Metadata File
events
Historical Pings for org-mozilla-fennec-aurora/events
org_mozilla_fennec_aurora.events
A historical view of pings sent for the
org-mozilla-fennec-aurora/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
| 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_fennec_aurora_stable | events_v1 |
Source Directory | View Definition | Metadata File
first_session
Historical Pings for org-mozilla-fennec-aurora/first-session
org_mozilla_fennec_aurora.first_session
A historical view of pings sent for the
org-mozilla-fennec-aurora/first-session
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
| 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_fennec_aurora_stable | first_session_v1 |
Source Directory | View Definition | Metadata File
fog_validation
Historical Pings for org-mozilla-fennec-aurora/fog-validation
org_mozilla_fennec_aurora.fog_validation
A historical view of pings sent for the
org-mozilla-fennec-aurora/fog-validation
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
| 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_fennec_aurora_stable | fog_validation_v1 |
Source Directory | View Definition | Metadata File
font_list
Historical Pings for org-mozilla-fennec-aurora/font-list
org_mozilla_fennec_aurora.font_list
A historical view of pings sent for the
org-mozilla-fennec-aurora/font-list
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
| 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_fennec_aurora_stable | font_list_v1 |
Source Directory | View Definition | Metadata File
fx_suggest
Historical Pings for org-mozilla-fennec-aurora/fx-suggest
org_mozilla_fennec_aurora.fx_suggest
A historical view of pings sent for the
org-mozilla-fennec-aurora/fx-suggest
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
| 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_fennec_aurora_stable | fx_suggest_v1 |
Source Directory | View Definition | Metadata File
history_sync
Historical Pings for org-mozilla-fennec-aurora/history-sync
org_mozilla_fennec_aurora.history_sync
A historical view of pings sent for the
org-mozilla-fennec-aurora/history-sync
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
| 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_fennec_aurora_stable | history_sync_v1 |
Source Directory | View Definition | Metadata File
installation
Historical Pings for org-mozilla-fennec-aurora/installation
org_mozilla_fennec_aurora.installation
A historical view of pings sent for the
org-mozilla-fennec-aurora/installation
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
| 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_fennec_aurora_stable | installation_v1 |
Source Directory | View Definition | Metadata File
logins_sync
Historical Pings for org-mozilla-fennec-aurora/logins-sync
org_mozilla_fennec_aurora.logins_sync
A historical view of pings sent for the
org-mozilla-fennec-aurora/logins-sync
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
| 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_fennec_aurora_stable | logins_sync_v1 |
Source Directory | View Definition | Metadata File
metrics
Historical Pings for org-mozilla-fennec-aurora/metrics
org_mozilla_fennec_aurora.metrics
A historical view of pings sent for the
org-mozilla-fennec-aurora/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
| 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_fennec_aurora_stable | metrics_v1 |
Source Directory | View Definition | Metadata File
migration
Historical Pings for org-mozilla-fennec-aurora/migration
org_mozilla_fennec_aurora.migration
A historical view of pings sent for the
org-mozilla-fennec-aurora/migration
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
| 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_fennec_aurora_stable | migration_v1 |
Source Directory | View Definition | Metadata File
pageload
Historical Pings for org-mozilla-fennec-aurora/pageload
org_mozilla_fennec_aurora.pageload
A historical view of pings sent for the
org-mozilla-fennec-aurora/pageload
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
| 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_fennec_aurora_stable | pageload_v1 |
Source Directory | View Definition | Metadata File
spoc
Historical Pings for org-mozilla-fennec-aurora/spoc
org_mozilla_fennec_aurora.spoc
A historical view of pings sent for the
org-mozilla-fennec-aurora/spoc
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
| 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_fennec_aurora_stable | spoc_v1 |
Source Directory | View Definition | Metadata File
startup_timeline
Historical Pings for org-mozilla-fennec-aurora/startup-timeline
org_mozilla_fennec_aurora.startup_timeline
A historical view of pings sent for the
org-mozilla-fennec-aurora/startup-timeline
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
| 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_fennec_aurora_stable | startup_timeline_v1 |
Source Directory | View Definition | Metadata File
sync
Historical Pings for org-mozilla-fennec-aurora/sync
org_mozilla_fennec_aurora.sync
A historical view of pings sent for the
org-mozilla-fennec-aurora/sync
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
| 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_fennec_aurora_stable | sync_v1 |
Source Directory | View Definition | Metadata File
tabs_sync
Historical Pings for org-mozilla-fennec-aurora/tabs-sync
org_mozilla_fennec_aurora.tabs_sync
A historical view of pings sent for the
org-mozilla-fennec-aurora/tabs-sync
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
| 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_fennec_aurora_stable | tabs_sync_v1 |
Source Directory | View Definition | Metadata File
topsites_impression
Historical Pings for org-mozilla-fennec-aurora/topsites-impression
org_mozilla_fennec_aurora.topsites_impression
A historical view of pings sent for the
org-mozilla-fennec-aurora/topsites-impression
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
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_fennec_aurora_stable | topsites_impression_v1 |
Source Directory | View Definition | Metadata File
use_counters
Historical Pings for org-mozilla-fennec-aurora/use-counters
org_mozilla_fennec_aurora.use_counters
A historical view of pings sent for the
org-mozilla-fennec-aurora/use-counters
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
| 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_fennec_aurora_stable | use_counters_v1 |
Source Directory | View Definition | Metadata File