SHOW statement

The SHOW statement can be used to replay changes made to the table.

Statement syntax

SHOW CHANGES FOR TABLE @tableName [SINCE "@timestamp"] [LIMIT @number]

Example usage

Basic usage

The following expression shows usugae of Show statment.

-- Replay changes to the reading table
SHOW CHANGES FOR TABLE reading SINCE "2023-09-07T01:23:52Z" LIMIT 10