Figure out a way for KaiRo's reports to query into raw JSON in the DB

RESOLVED FIXED

Status

RESOLVED FIXED
6 years ago
5 years ago

People

(Reporter: kairo, Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

6 years ago
As we have the raw JSON in the DB now, I'd like to have my reports be able to do queries against it. I'd like to get info like devices or Android versions etc. to put into those reports.

I'm using the analyst user atm, which I guess doesn't have access to the raw JSON as that contains stuff like URLs and emails.

Also, I'd like to know how to efficiently do queries against fields of that raw JSON once I have access.
(Reporter)

Comment 1

6 years ago
Selena, you said on IRC that this data isn't even in the DB yet. Do I get it correctly that bug 866960 is the missing piece that will give us that?

If so, I guess we should look into the request in this bug once that has landed in prod.
(Reporter)

Comment 2

5 years ago
It is in the DB now and Selena created a DB user for CrashKill people to use with full read access to all data, so this bug is fixed.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.