Skip to content

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

Source Directory

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

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

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

Schema
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
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod eng_workflow_stable hgpush_v1

Source Directory | View Definition | Metadata File