962
edits
Thunderbird/Support/Google Big Query Sample SQL queries: Difference between revisions
Thunderbird/Support/Google Big Query Sample SQL queries (view source)
Revision as of 15:44, 28 August 2025
, 28 Augustworking query as of august 18th, 2025
(add desktop results) |
(working query as of august 18th, 2025) |
||
| Line 1: | Line 1: | ||
__TOC__ | __TOC__ | ||
== 2025-08-18 queries have changed to project 'sumo-prod', folder 'moz-fx-sumo-prod' and dataset is SUMO== | |||
* The pre August 18, 2025m queries on the rest of this page no longer work therefore :-) | |||
* They will work if you change the project (top left corner of the screen) to <code>sumo-prod</code> and the folder to <code>moz-fx-sumo-prod</code> and the table to <code>sumo.metrics_thunderbird_questions</code> <-- This is left as an exercise for the reader :-) | |||
===Working query=== | |||
* [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-sumo-prod!2sus-central1!3sf5d1cd21-5978-4b69-874f-f0a02d503f8a!2e1 staff only link to BQ query] | |||
<pre> | |||
SELECT * FROM `sumo.metrics_thunderbird_questions` LIMIT 1000 | |||
</pre> | |||
== Count All Solved Android Desktop Questions in 2024 == | == Count All Solved Android Desktop Questions in 2024 == | ||
* [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-data-sumo-prod!2snorthamerica-northeast1!3s1f1e6c74-be25-48e4-afa9-72f0704828c0!2e1 staff only link to BQ query] | * [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-data-sumo-prod!2snorthamerica-northeast1!3s1f1e6c74-be25-48e4-afa9-72f0704828c0!2e1 staff only link to BQ query] | ||