Skip to content

Instantly share code, notes, and snippets.

@robotblake

robotblake/redash_results.md Secret

Last active October 18, 2016 19:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save robotblake/aaa6f35195f6466aa8086be8162dd33a to your computer and use it in GitHub Desktop.
Save robotblake/aaa6f35195f6466aa8086be8162dd33a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redash_results.md

Accessing re:dash results externally

After you've created your query and everything is working, go to the query edit page and click on the little 3 dots menu in the screen below. Query Source Page You'll want to click on the Show API Key button which will give you a pop-up with the api_key for accessing the results for that particular query. You'll also want to pay attention to the query_id from the URL bar, in the attached photo it's 764.

The URL you'll want to use is as follows:
https://sql.telemetry.mozilla.org/api/queries/<query_id>/results.json?api_key=<api_key>

The json format returned by re:dash is documented here.

Alternatively if you'd like it to just return a CSV, you can replace the .json in the URL with .csv.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment