VIEW, the result of an aggregation is stored in a table.
eventsstream contains several events, in the following format:
APPEND ON DUPLICATE
APPEND ON DUPLICATE, the table will instead be appended to, resulting in multiple rows with the same keys in the final table.
APPEND ON DUPLICATE:
APPEND ON DUPLICATEwill result in having several rows per
event_timein the output table, each with a different amount of events.
WINDOWclause optionally sets the amount of time until data is expired out of the result.
event_timeand aggregate those over a 30 days window:
MAX DELAYwill filter out data that arrives delayed by more than the max delay.
event_timeup to 3 days back: