Changes on mozillians.org database

VERIFIED FIXED

Status

VERIFIED FIXED
5 years ago
5 years ago

People

(Reporter: pclemente, Assigned: giorgos)

Tracking

Details

(URL)

(Reporter)

Description

5 years ago
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,
(Assignee)

Comment 1

5 years ago
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.
Assignee: nobody → giorgos
Status: NEW → RESOLVED
Last Resolved: 5 years ago
OS: Mac OS X → All
Hardware: x86 → All
Resolution: --- → FIXED
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?
Flags: needinfo?(hoosteeno)
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.
Flags: needinfo?(hoosteeno)
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 :)
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.