eng-workflow
User-facing views related to document namespace eng-workflow; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/eng-workflow
bmobugs
Historical Pings for eng-workflow/bmobugs
eng_workflow.bmobugs
A historical view of pings sent for the
eng-workflow/bmobugs
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 |
| assigned_to | Integer | Yes | |
| blocked_by | Integer | No | |
| bug_id | Integer | Yes | |
| bug_severity | String | Yes | |
| bug_status | String | Yes | |
| component | String | Yes | |
| creation_ts | String | Yes | |
| delta_ts | String | Yes | |
| depends_on | Integer | No | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| duplicate_of | Integer | Yes | |
| duplicates | Integer | No | |
| flags | Record | No | |
| groups | String | No | |
| keywords | String | No | |
| 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 | |
| priority | String | Yes | |
| product | String | Yes | |
| qa_contact | Integer | Yes | |
| reporter | Integer | Yes | |
| resolution | 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 |
| target_milestone | String | Yes | |
| version | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | eng_workflow_stable | bmobugs_v1 |
Source Directory | View Definition | Metadata File
build
Historical Pings for eng-workflow/build
eng_workflow.build
A historical view of pings sent for the
eng-workflow/build
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 |
| argv | String | No | |
| build_attrs | Attributes characterizing a build | Record | Yes |
| build_opts | Selected build options | Record | Yes |
| client_id | A UUID to uniquely identify a client | String | Yes |
| command | The mach command that was invoked | String | Yes |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| duration_ms | Command duration in milliseconds | Float | Yes |
| exception | If a Python exception was encountered during the execution of the command, this value contains the result of calling `repr` on the exception object. | String | Yes |
| file_types_changed | Record | No | |
| 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 | |
| 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 |
| success | true if the command succeeded | Boolean | Yes |
| system | Record | Yes | |
| time | Time at which this event happened | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | eng_workflow_stable | build_v1 |
Source Directory | View Definition | Metadata File
hgpush
Historical Pings for eng-workflow/hgpush
eng_workflow.hgpush
A historical view of pings sent for the
eng-workflow/hgpush
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 |
| changeset_id | The 40 char hex ID of the changeset. See https://www.mercurial-scm.org/wiki/ChangeSetID. | String | Yes |
| diffstat | Statistics about files changed by this changeset. Similar to running 'hg diff --stat'. May be null if diffstats were not computed. | Record | Yes |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| landing_system | A string labelling the automated system used to land this changeset in this repository. May be empty. | 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 | |
| push_date | Timestamp, in Unix time (seconds since the Unix epoch), of when the push to the repository occurred. This value is obtained from the original repository pushlog. | Integer | Yes |
| repository | The URL of the repository the changeset was pushed to. | String | Yes |
| review_system_used | A string labelling the code review system used to review this changeset. Possible values include (but are not limited to): 'mozreview', 'phabricator', 'bmo', 'unknown', and 'not_applicable'. | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | eng_workflow_stable | hgpush_v1 |
Source Directory | View Definition | Metadata File