WAEvent contents for change data
The output data type for sources that use change data capture readers is WAEvent. The fields and valid values vary among the readers, but they all include the following:
metadata: a map including the elements:
OperationName: INSERT, UPDATE, or DELETE
TxnID: transaction ID
TimeStamp: timestamp from the CDC log
TableName: fully qualified name of the table on which the operation was performed
To retrieve the values for these fields, use the META() function. See Parsing the fields of WAEvent for CDC readers.
data: an array of fields, numbered from 0, containing:
for an INSERT or DELETE operation, the values that were inserted or deleted
for an UPDATE, the values after the operation was completed
To retrieve the values for these fields, use SELECT ... (DATA[])
. See Parsing the fields of WAEvent for CDC readers.
before (for UPDATE operations only): the same format as data, but containing the values as they were prior to the UPDATE operation
dataPresenceBitMap, beforePresenceBitMap , and typeUUID are reserved and should be ignored.
For information on additional fields and detailed discussion of values, see: