Custom dashboards with re:dash: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
(Adding external resources)
(Redirecting to telemetry/)
 
Line 1: Line 1:
==Introduction==
#REDIRECT [[Telemetry/Custom dashboards with re:dash]]
Re:dash allows you to connect to various data sources via an interactive SQL frontend. You can then share your queries with peers, create visualizations, or combine these into an automatically updating dashboard.
 
Check it out at [sql.telemetry.mozilla.org]. re:dash is also known as stmo, an abbreviation of it's URL.
 
==Available Data Sets==
 
===Longitudinal Data===
{{longitudinal data intro}}
 
See [[Telemetry/LongitudinalExamples]] for a discussion of the data and example queries.
 
===Google Sheets===
 
To access a Google Sheet from re:dash:
* Share the spreadsheet with "gspread@pipeline-sql-prod.iam.gserviceaccount.com".
* Google will warn you that this address is not within Mozilla. Click "OK"
* Find the document ID for the given spreadsheet.
** For example, a URL like "https://docs.google.com/spreadsheets/d/1-DaBLABLAmu_lVGunk8I/edit#gid=1507574279" has an id of "1-DaBLABLAmu_lVGunk8I"
* Paste this id into the query box in sql.telemetry.mozilla.org.  As an example, see https://sql.telemetry.mozilla.org/queries/476/source
* You should see your spreadsheet data appear in re:dash
 
Thanks to Mark Reid and Blake Imsland for sharing!
 
==Other Resources==
* [https://robertovitillo.com/2016/03/27/telemetry-meets-sql/]

Latest revision as of 00:53, 30 July 2016

Redirect to:

Retrieved from "https://wiki.allizom.org/index.php?title=Custom_dashboards_with_re:dash&oldid=1141916"