-
Notifications
You must be signed in to change notification settings - Fork 100
/
view.sql
30 lines (30 loc) · 893 Bytes
/
view.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
-- Generated via ./bqetl generate glean_usage
CREATE OR REPLACE VIEW
`moz-fx-data-shared-prod.firefox_reality_pc.deletion_request`
AS
SELECT
"org_mozilla_firefoxreality" AS normalized_app_id,
normalized_channel,
additional_properties,
client_info,
document_id,
events,
metadata,
STRUCT(
STRUCT(
metrics.labeled_counter.glean_error_invalid_label,
metrics.labeled_counter.glean_error_invalid_overflow,
metrics.labeled_counter.glean_error_invalid_state,
metrics.labeled_counter.glean_error_invalid_value
) AS `labeled_counter`,
STRUCT(metrics.string.glean_client_annotation_experimentation_id) AS `string`
) AS `metrics`,
normalized_app_name,
normalized_country_code,
normalized_os,
normalized_os_version,
ping_info,
sample_id,
submission_timestamp
FROM
`moz-fx-data-shared-prod.org_mozilla_firefoxreality.deletion_request`