-
Notifications
You must be signed in to change notification settings - Fork 100
/
view.sql
22 lines (22 loc) · 879 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
-- Generated via ./bqetl generate stable_views
CREATE OR REPLACE VIEW
`moz-fx-data-shared-prod.org_mozilla_fenix_nightly.migration`
AS
SELECT
* REPLACE (
mozfun.norm.metadata(metadata) AS metadata,
mozfun.norm.glean_ping_info(ping_info) AS ping_info,
(
SELECT AS STRUCT
metrics.* EXCEPT (jwe, labeled_rate, text, url) REPLACE(
STRUCT(
mozfun.glean.parse_datetime(
metrics.datetime.migration_telemetry_identifiers_fennec_profile_creation_date
) AS migration_telemetry_identifiers_fennec_profile_creation_date,
metrics.datetime.migration_telemetry_identifiers_fennec_profile_creation_date AS raw_migration_telemetry_identifiers_fennec_profile_creation_date
) AS datetime
)
) AS metrics
)
FROM
`moz-fx-data-shared-prod.org_mozilla_fenix_nightly_stable.migration_v1`