Add insert/update/delete triggers in Clickhouse

Viewed 22

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;
0 Answers
Related