I am using AWS Redshift to run the query.
The query contains create table and join with existing tables procedure.
There is an updated_at field for the new table after all procedures, which is current time.
After all procedures, updated_at is at current time. However, if I click the 'Refresh' button using SQL Workbench J, this field changed to last time it was successfully queried.
I think this means table is failed updated, how could I fix it? Thanks!
Select 'autocommit' under connection profile page works for me.