Metadata

Streamkap Connectors (where applicable) insert the following metadata columns into the data and destination tables:

Column NameDescription
_STREAMKAP_SOURCE_TS_MSTimestamp in milliseconds (UTC) for when the event occurred in the source database
_STREAMKAP_TS_MSTimestamp in milliseconds (UTC) for when Streamkap received the event
__DELETEDIndicates whether this event/row has been deleted in the source database
_STREAMKAP_OFFSETThis is an offset value in relation to the events we process. It can be useful in the debugging of any issues that may arise