How to get sequence number of the event?

NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.

Use SQL-code below to get sequence number of event:

SELECT
  event_name,
  SPLIT(owox.event_id,'/')[ORDINAL(1)] as event_id,
  SPLIT(owox.event_id,'/')[ORDINAL(2)] as part,
  SPLIT(owox.event_id,'/')[SAFE_ORDINAL(3)] as auto_event
FROM
  `{{project}}.{{dataset}}.events_intraday_{{date}}`