Telemetry/Custom dashboards with re:dash: Difference between revisions
Jump to navigation
Jump to search
(Adding main_summary stub) |
(Update Available Datasets) |
||
| Line 6: | Line 6: | ||
==Available Data Sets== | ==Available Data Sets== | ||
We have a variety of datasets available for querying. [https://wiki.mozilla.org/Telemetry/Available_Telemetry_Datasets_and_their_Applications Available Datasets] | |||
===Google Sheets=== | ===Google Sheets=== | ||
| Line 23: | Line 17: | ||
* Paste this id into the query box in sql.telemetry.mozilla.org. As an example, see https://sql.telemetry.mozilla.org/queries/476/source | * 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 | * You should see your spreadsheet data appear in re:dash | ||
==Other Resources== | ==Other Resources== | ||
* [https://robertovitillo.com/2016/03/27/telemetry-meets-sql/] | * [https://robertovitillo.com/2016/03/27/telemetry-meets-sql/] | ||
Revision as of 16:54, 23 September 2016
Introduction
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
We have a variety of datasets available for querying. Available Datasets
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