Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT
  2. x.value.string_value AS lat,
  3. y.value.string_value AS lon,
  4. geo.city
  5. FROM
  6. `apps.analytics_185684181.*`,
  7. UNNEST(user_properties) AS x,
  8. UNNEST(user_properties) AS y,
  9. UNNEST(user_properties) AS z
  10. WHERE
  11. x.key="user_loc_lat"
  12. AND y.key="user_loc_lon"
  13. AND event_name='event_name'
  14. AND (_TABLE_SUFFIX BETWEEN 'events_20190301'
  15. AND 'events_20190331')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement