1422071 - Provide a git centric model for maintaining SQL queries

Status: RESOLVED FIXED

(Data Platform and Tools :: General, enhancement, P2)

Description

[Ryan Harter [:harter]]

I'm working on this here [1]

When building the 57 Release Dashboard [2] our team had to collaboratively build a half dozen queries to be displayed on office monitors. I noted a few tooling/process issues:

* It was difficult to comment on specific parts of queries
* It was difficult to identify whether someone had approved a given query
* Version tracking is insufficient in re:dash

These problems can all be fixed by treating our queries as code and keeping them in git. My proposed fix is to provide a cli for STMO that allows us to easily upload queries to re:dash. 

[1] https://github.com/mozilla/stmocli
[2] https://strategy-and-insights.mozilla.com/topline-metrics/index.html

Comment 1

[Ryan Harter [:harter]]

Calling this bug done. St. Mocli [1] can now track queries in a git repository and upload version controlled queries to re:dash. This now powers the fx_usage_report repo [2].

[1] https://github.com/mozilla/stmocli
[2] https://github.com/mozilla/fx_usage_report