Implicit Columns

All streams, windows, and delta streams use three implicit columns called ROWID, ROWTIME, and BIGROWTIME.

• ROWID – provides a unique row identification number for each row of incoming data.
• ROWTIME – provides the last modification time as a date with second precision.
• BIGROWTIME – provides the last modification time of the row with microsecond precision. You can perform filters and selections based on these columns, like filtering out all of those data rows that occur outside of business hours.