CREATE TABLE IF NOT EXISTS ERN_ARCHIVE.TEST_TABLE (ID VARCHAR(36) NOT NULL PRIMARY KEY, DATA VARCHAR);
UPSERT INTO ERN_ARCHIVE.TEST_TABLE(ID, DATA) VALUES('1', 'data1');
SELECT * FROM ERN_ARCHIVE.TEST_TABLE;
UPSERT INTO ERN_ARCHIVE.TEST_TABLE(ID, DATA) VALUES('1', 'data2');
SELECT * FROM ERN_ARCHIVE.TEST_TABLE;
UPSERT INTO ERN_ARCHIVE.TEST_TABLE(ID, DATA) VALUES('1', NULL);
SELECT * FROM ERN_ARCHIVE.TEST_TABLE;