create_realtime_view.sql

-- This query is not valid as there is no realtime data available in the sample data set.
CREATE VIEW
  `project.dataset.ga_realtime_view` AS
SELECT
  PARSE_DATE('%y%m%d',
    _TABLE_SUFFIX) AS suffix,
  visitKey AS visitKey2,
  ARRAY_AGG(t
  ORDER BY
    exportTimeUsec DESC
  LIMIT
    1)[
OFFSET
  (0)].*
FROM
  `project.dataset.ga_realtime_sessions_20*` AS t
GROUP BY
  suffix,
  visitKey2