Telemetry/Custom dashboards with re:dash: Difference between revisions
(Update Available Datasets) |
(→Available Data Sets: change to available data sources) |
||
| Line 4: | Line 4: | ||
Check it out at [sql.telemetry.mozilla.org]. re:dash is also known as stmo, an abbreviation of it's URL. | Check it out at [sql.telemetry.mozilla.org]. re:dash is also known as stmo, an abbreviation of it's URL. | ||
==Available Data | ==Available Data Sources== | ||
We have a variety of datasets available for querying. [https://wiki.mozilla.org/Telemetry/Available_Telemetry_Datasets_and_their_Applications | re:dash is data source agnostic. As such we have many different data sources available, where each will have their own tables to query from. | ||
To choose a different data source, select it from the dropdown next to "Data Source". To see what tables are available, simply select the data source and execute <code>show tables</code>. Some data sources will have the tables and schemas show up in a table to the left of the query writing field. | |||
===Presto=== | |||
We have a variety of datasets available for querying. [https://wiki.mozilla.org/Telemetry/Available_Telemetry_Datasets_and_their_Applications Full Documentation] | |||
===Google Sheets=== | ===Google Sheets=== | ||
Revision as of 19:41, 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 Sources
re:dash is data source agnostic. As such we have many different data sources available, where each will have their own tables to query from.
To choose a different data source, select it from the dropdown next to "Data Source". To see what tables are available, simply select the data source and execute show tables. Some data sources will have the tables and schemas show up in a table to the left of the query writing field.
Presto
We have a variety of datasets available for querying. Full Documentation
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