Redash Query Tool
Query Mozilla's Redash (sql.telemetry.mozilla.org) for telemetry data. Redash is the front-end to BigQuery telemetry data.
Knowledge References
@references/README.md @references/fxci-schema.md
Prerequisites
REDASH_API_KEYenvironment variable setuvfor running the script
Quick Start
# Run custom SQL
uv run scripts/query_redash.py --sql "SELECT * FROM telemetry.main LIMIT 10"
# Fetch cached results from an existing Redash query
uv run scripts/query_redash.py --query-id 65967
# Save results to file
uv run scripts/query_redash.py --sql "SELECT 1" --output ~/moz_artifacts/data.json
Usage
Either --sql or --query-id is required.
| Flag | Description |
|---|---|
--sql | SQL query to execute against BigQuery via Redash |
--query-id | Fetch cached results from an existing Redash query ID |
--output, -o | Save results to JSON file |
--format, -f | Output format: json, csv, table (default: table) |
--limit | Limit number of rows displayed |
Example Prompts
These natural language prompts map to queries in references/common-queries.md:
| Prompt | Query used |
|---|---|
| "What's the DAU breakdown by macOS version?" | macOS Version DAU (active_users_aggregates) |
| "Show me macOS version × architecture distribution" | macOS version × arch (baseline_clients_daily) |
| "What share of macOS users are on Apple Silicon?" | macOS version × arch, compare aarch64 vs x86_64 |
| "Pull the macOS DAU and arch breakdown for the last 28 days" | Both macOS queries |
| "What Windows versions are Firefox Desktop users on?" | Windows Version Distribution (query 65967) |
| "How many Firefox users are on Windows 11?" | Windows Version Distribution |
| "What does the macOS adoption curve look like over time?" | macOS Version DAU by os_version_major |
For questions not covered by a documented query, write SQL on the fly using the table references in references/README.md.
Common Queries
@references/common-queries.md