1056771 - [Baloo] Automating github aggregations from MoFo integration DB

Status: RESOLVED FIXED

(Community Building :: Systems and Data, task)

Description

[Pierros Papadeas [:pierros]]

Github aggregations need to be automated using the MoFo integration DB.

See 1042057 for details on access.

Comment 1

[Sheeri Cabral [:sheeri]]

Working on this now, so far I have gotten:
- data into the raw table
- new contributors into the contributor table
- new repos into the github_repo table
- new github organizations into the github_org table
- set the team for each repo, where applicable, using https://docs.google.com/a/mozilla.com/spreadsheets/d/1cMZQYEmEiuDTAY93j4siiq58exaMZOa2o3YdoLyEYTI/edit#gid=0
- data into the facts table (aggregated from the raw table)

Comment 2

[Sheeri Cabral [:sheeri]]

I have integrated the facts table into contributor_facts, and am now going back through to 2010 and doing the weekly active contributor data. Will post here and e-mail when the github numbers are complete and can be seen in Tableau.

Comment 3

[Sheeri Cabral [:sheeri]]

The github numbers were complete last week, around 9/2. Things are automated from this table.