Description:
Revision registry for audit tables. One row per revision number (rev). This is the only source of wall-clock time for a vehicles_aud row — join on rev to find out when a given audit revision actually happened. See vehicles_aud for the join example and a worked service-state/downtime reconstruction.
🔑 Primary Key
rev
| Field Name | Data Type | Description |
|---|---|---|
rev |
NUMBER | Revision number. Join target for vehicles_aud.rev. |
revtstmp |
NUMBER | Wall-clock time of this revision, as epoch milliseconds. Convert with TO_TIMESTAMP(revtstmp, 3). |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |