909722 - Changes on mozillians.org database

Status: VERIFIED FIXED

(Participation Infrastructure :: Phonebook, defect)

Description

[Paula Clemente [:paula]]

Hi,

We have an ETL that runs daily to feed the mozillians.org dashboard: 
https://metrics.mozilla.com/pentaho/content/pentaho-cdf-dd/Render?solution=metrics2&path=mozillians&file=mozillians.wcdf

Today we got this error:
- Table 'mozillians_org.group' doesn't exist

Can someone check what is happening, please?

Thanks,

Comment 1

[Giorgos Logiotatidis [:giorgos]]

We changed the table name to 'groups_group' to much the schema of the rest of the app. Sorry that you're not informed before that change, I wasn't aware you're directly hitting our db.

Comment 2

[Matt Brandt [:mbrandt]]

Is this something that the upcoming api will take into account. Are there additional requirements that we can capture for the api that will take into account metrics needs?

Comment 3

[Justin Crawford [:hoosteeno] [:jcrawford]]

In bug 908702 we describe some API work related to aggregate data that resembles metrics data, but it isn't a 1-for-1 match. I'd be glad to consider a bug/s to provide endpoints for aggregate data serving metrics team needs. It might be a good idea to get rid of an unnecessary database access if we can provide these aggregate data somehow else.

Comment 4

[Matt Brandt [:mbrandt]]

Bumping to verified per comment 3 - please file follow up bugs and/or work with hoosteeno to map out your data needs and we'll do our best to open up the data for you :)