Is there a way to add insert/update/delete triggers in Clickhouse to keep track of changes in a specific table to write data that has been changed to another table.
Here is a similar script for Oracle:
CREATE OR REPLACE TRIGGER trigger_name
AFTER
INSERT OR UPDATE OR DELETE
ON table_name
FOR EACH ROW
DECLARE
action_type VARCHAR2(6);
BEGIN
action_type := CASE
WHEN INSERTING THEN 'insert'
WHEN UPDATING THEN 'update'
WHEN DELETING THEN 'delete'
END;
INSERT INTO ...
END;