coverage
User-facing views related to document namespace coverage; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/coverage
coverage
Historical Pings for coverage/coverage
coverage.coverage
A historical view of pings sent for the
coverage/coverage
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 |
| app_update_channel | String | Yes | |
| app_version | String | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| metadata | 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 | |
| os_name | String | Yes | |
| os_version | String | 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 |
| telemetry_enabled | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | coverage_stable | coverage_v1 |
Source Directory | View Definition | Metadata File