Page MenuHomePhabricator
Create Task
Maniphest T71145

Story: AnalyticsEng has editor_day table in labsdb
Closed, DeclinedPublic
Actions

Description

We need to create a permanent and vetted version the "editor_day" table from the analytics-store box in labsdb. Then, change Rolling Active Editor to use that table instead of the raw database. Without it, 'Rolling Active Editor' will never finish on time.

Version: unspecified
Severity: normal
Whiteboard: u=AnalyticsEng c=Wikimetrics p= 34 s=2014-11-13

Details

Reference
bz69145

Related Objects
Search...

Event Timeline

• bzimport raised the priority of this task from to Unbreak Now!.Nov 22 2014, 3:37 AM
• bzimport added a project: Analytics-Wikimetrics.
• bzimport set Reference to bz69145.
• bzimport added a subscriber: Unknown Object (MLST).
• Nuria created this task.Aug 5 2014, 1:53 PM
• kevinator added a comment.Aug 7 2014, 7:30 PM

Collaborative tasking done in etherpad:
http://etherpad.wikimedia.org/p/analytics-69145

• kevinator added a comment.Aug 8 2014, 4:19 PM
  • Bug 69254 has been marked as a duplicate of this bug. ***
• kevinator added a project: Analytics-Engineering.Nov 26 2014, 12:44 AM
• kevinator set Security to None.
• kevinator lowered the priority of this task from Unbreak Now! to High.Nov 26 2014, 12:50 AM
• kevinator moved this task from Incoming to Coding and Testing on the Analytics-Engineering board.
• kevinator renamed this task from Story: AnalyticsEng has editor_day table in labsdb to Story: AnalyticsEng has editor_day table in labsdb [34pts].Nov 26 2014, 1:02 AM
• kevinator added a project: Analytics-Sprint-2014-11-13.Nov 26 2014, 9:47 PM
• kevinator removed a project: Analytics-Engineering.Nov 26 2014, 11:25 PM
• ggellerman renamed this task from Story: AnalyticsEng has editor_day table in labsdb [34pts] to Story: AnalyticsEng has editor_day table in labsdb .Dec 1 2014, 9:25 PM
• ggellerman subscribed.Dec 1 2014, 9:28 PM

Was 38 points...removing points from subj line because:

  1. This ticket had been in progress for some time. Team came to consensus that it was too big and changed scope of this ticket to encompass:
  • create rough draft of schema and data loading queries (gerrit)
  • create warehouse on stat1003 and grant access to research user with preliminary schema
  • vet data loaded by Sean (user table and edit tables)
    • this includes work by sean (tunning, perf & index creation)
    • sanity checking by analytics devs
    • run sample queries for metrics `
  1. other tasks from this ticket are now covered by https://phabricator.wikimedia.org/T76382

see also
https://etherpad.wikimedia.org/p/analytics-tasking

fbstj mentioned this in T76382: EPIC: data warehouse.Dec 9 2014, 6:59 PM
• kevinator lowered the priority of this task from High to Low.Feb 26 2015, 7:26 PM
• kevinator added a project: Analytics-Kanban.
• ggellerman edited projects, added Analytics-Backlog; removed Analytics-Kanban.Jun 12 2015, 9:35 PM
• kevinator moved this task from Incoming to Backlog on the Analytics-Backlog board.Jun 30 2015, 10:40 PM
• ggellerman edited projects, added Analytics; removed Analytics-Backlog.Jan 12 2016, 7:42 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 12 2016, 7:42 PM
Milimetric moved this task from Incoming to Event Platform on the Analytics board.Jan 12 2016, 7:42 PM
Danny_B added a project: Story.May 23 2016, 11:46 AM
Milimetric moved this task from Event Platform to Deprioritized on the Analytics board.Sep 19 2016, 4:15 PM
• ggellerman unsubscribed.Sep 19 2016, 4:30 PM
mforns closed this task as Declined.Mar 26 2019, 2:33 PM
mforns subscribed.

Declining because Wikimetrics is being discontinued. See: T211835.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL