Bugzilla

(In reply to Alessio Placitelli [:Dexter] from comment #14)
> Hey Arkadiusz, what do you think of the above? Are debug view pings getting into the same dataset as non debug ones?

Yes, they are, that was one of our requirements.

As for telling them apart from the real pings - we can do this, but only on GCP because headers aren't stored in direct-to-parquet tables on AWS (`org_mozilla_fenix_metrics_parquet`).

It looks like BigQuery Glean tables aren't available via Redash yet, so I ran the following query to see how many debug metrics pings we got in July (there was 1):
```
SELECT
  COUNTIF(metadata.header.x_debug_id IS NOT NULL) AS num_debug_view,
  COUNTIF(metadata.header.x_debug_id IS NULL) AS num_prod,
  DATE(submission_timestamp) AS day
FROM
  `moz-fx-data-shared-prod.org_mozilla_fenix.metrics_v1`
WHERE
  DATE(submission_timestamp) >= "2019-07-01"
GROUP BY
  day
ORDER BY
  day
```
```
day	num_debug_view	num_prod
2019-07-01	0	76360
2019-07-02	0	79653
2019-07-03	0	80621
2019-07-04	1	80713
2019-07-05	0	80642
2019-07-06	0	80261
2019-07-07	0	81135
2019-07-08	0	81469
2019-07-09	0	81148
2019-07-10	0	81309
2019-07-11	0	81107
2019-07-12	0	80844
2019-07-13	0	80556
2019-07-14	0	80564
2019-07-15	0	80834
2019-07-16	0	65571
```

(In reply to Alessio Placitelli [:Dexter] from comment #14)
> Hey Arkadiusz, what do you think of the above? Are debug view pings getting into the same dataset as non debug ones?

Yes, they are, that was one of our requirements.

As for telling them apart from the real pings - we can do this, but only on GCP because headers aren't stored in direct-to-parquet tables on AWS (`org_mozilla_fenix_metrics_parquet`).

I ran the following query to see how many debug metrics pings we got in July (there was 1):
https://sql.telemetry.mozilla.org/queries/63651/source