Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- x.value.string_value AS lat,
- y.value.string_value AS lon,
- geo.city
- FROM
- `apps.analytics_185684181.*`,
- UNNEST(user_properties) AS x,
- UNNEST(user_properties) AS y,
- UNNEST(user_properties) AS z
- WHERE
- x.key="user_loc_lat"
- AND y.key="user_loc_lon"
- AND event_name='event_name'
- AND (_TABLE_SUFFIX BETWEEN 'events_20190301'
- AND 'events_20190331')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement