Closed Bug 868188 Opened 9 years ago Closed 8 years ago

UI for looking at data_dictionary

Categories

(Socorro :: Webapp, task)

x86_64
Linux
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: peterbe)

References

Details

(Whiteboard: [qa-])

Attachments

(1 file)

I'd love a way to have a look at data_dictionary, which contains information about transformations of data from breakpad variables to various parts of Socorro.

We have three columns: 

* raw_field: the breakpad variable in meta_data (HBase)
* product: currently NULL, but important and interesting for differentiating between things like Fennec and B2G
* transforms: a JSON blob that has keys and sometimes values that explain how a raw_field is transformed and also where it is transformed
Target Milestone: --- → 48
I don't know what `data_dictionary` is. Is it a database table?

Guessing that it is a table, to get this UI we'd need to write an implementation, a middleware and some place to show the data. 

Would it work if I build a page on the Admin pages of socorro-crashstats?
(In reply to Peter Bengtsson [:peterbe] from comment #1)
> I don't know what `data_dictionary` is. Is it a database table?

Yes! It is a database table.

It contains information about how data is transformed from a raw metadata crash field, into something that is inserted into PostgreSQL. The JSON comes from a spreadsheet that Lars put together a while ago. I was hoping to create this interface to keep track of new fields (currently very difficult), and encourage people to keep sane variable names.

> Guessing that it is a table, to get this UI we'd need to write an
> implementation, a middleware and some place to show the data. 

I'll make a ticket for the middleware.

> Would it work if I build a page on the Admin pages of socorro-crashstats?

Yes, that would be ideal.
Depends on: 872223
Target Milestone: 48 → 49
Assignee: nobody → peterbe
Target Milestone: 49 → 51
Target Milestone: 51 → 52
Note-to-self: Here are some sample keys you can use in dev https://gist.github.com/selenamarie/17440b314f380ecf1647
Target Milestone: 52 → 54
Status: NEW → RESOLVED
Closed: 8 years ago
Resolution: --- → FIXED
Target Milestone: 54 → 52
Whiteboard: [qa-]
You need to log in before you can comment on or make changes to this bug.