This dataset records facts about individual commits to the Firefox source tree
The dataset is accessible via
eng_workflow_hgpush_parquet_v1 table with the
Athena data source.
Presto data source is also available, but much slower.)
hgpush ping schema
for a description of available fields.
Be careful to:
- Use the latest schema version. e.g.
v1. Browse the
hgpushschema directory in the GitHub repo to be sure.
- Change dataset field names from
under_score_namesin STMO. e.g.
reviewSystemUsedin the ping schema becomes
Select the number of commits with an 'unknown' review system in the last 7 days:
select count(1) from eng_workflow_hgpush_parquet_v1 where review_system_used = 'unknown' and date_diff('day', from_unixtime(push_date), now()) < 7
The dataset is populated via the Commit Telemetry Service.