...
The Database Command in the PostgreSQL Execute action looks like:
BEGIN;
INSERT INTO final_table (id, date)
SELECT id, date FROM staging_table
ON CONFLICT (id) DO UPDATE
SET date = excluded.date;
TRUNCATE staging_table;
COMMIT;
...
...
The Database Command in the PostgreSQL Execute action looks like:
BEGIN;
INSERT INTO final_table (id, date)
SELECT id, date FROM staging_table
ON CONFLICT (id) DO UPDATE
SET date = excluded.date;
TRUNCATE staging_table;
COMMIT;
...