silly-fall-70535
08/12/2023, 1:06 AMfresh-football-47124
silly-fall-70535
08/12/2023, 1:11 AMfresh-football-47124
silly-fall-70535
08/12/2023, 1:14 AMSELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp
FROM
`pathology-699c4`.`analytics_341966914`.`events_*`
WHERE
event_name = 'page_view'
AND event_params.key = 'page_location'
AND event_params.value='<https://pathology.gg/tutorial>'
AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
Cannot access field key on a value with type ARRAY<STRUCT<key STRING, value STRUCT<string_value STRING, int_value INT64, float_value FLOAT64, ...>>> at [11:24]
fresh-football-47124
UNNEST(event_params) AS page_view_params
page_view_params.key = "whatever"
silly-fall-70535
08/12/2023, 1:18 AMSELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
UNNEST(event_params) AS page_view_params
FROM
`pathology-699c4`.`analytics_341966914`.`events_*`
WHERE
event_name = 'page_view'
AND event_params.key = 'page_location'
AND event_params.value='<https://pathology.gg/tutorial>'
AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
Syntax error: Expected ")" but got keyword UNNEST at [5:7]
fresh-football-47124
silly-fall-70535
08/12/2023, 1:19 AMfresh-football-47124
silly-fall-70535
08/12/2023, 1:20 AMSELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp
FROM
`pathology-699c4`.`analytics_341966914`.`events_*`,
UNNEST(event_params) AS page_view_params
WHERE
event_name = 'page_view'
AND page_view_params.key = 'page_location'
AND page_view_params.value = '<https://pathology.gg/tutorial>'
AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
SELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp
FROM
`pathology-699c4`.`analytics_341966914`.`events_*`,
UNNEST(event_params) AS page_view_params
WHERE
event_name = 'page_view'
AND page_view_params.key = 'page_location'
AND page_view_params.value.string_value = '<https://pathology.gg/tutorial>'
AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
fresh-football-47124
silly-fall-70535
08/12/2023, 1:21 AMfresh-football-47124
silly-fall-70535
08/12/2023, 1:23 AMfresh-football-47124
silly-fall-70535
08/12/2023, 1:30 AMfresh-football-47124