CREATE MATERIALIZED VIEW ss_mv ASWITH sub AS CHANGELOG FROM user_behaviorsSELECT user_id, target_id, event_timestamp AT TIME ZONE 'America/Indiana/Indianapolis' AS event_timestamp, changelog_op AS __op, _changelog_row_id::bigint AS __row_idFROM sub;
Changelog operation
Copy
Ask AI
INSERT INTO user_behaviors (v1, v2) VALUES (1, 1);INSERT INTO user_behaviors (v1, v2) VALUES (2, 2);DELETE FROM user_behaviors WHERE v1 = 2;UPDATE user_behaviors SET v2 = 100 WHERE v1 = 1;