Failed updating table for Redshift

Question

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!

Are you saying that every time you click 'refresh', that field is changing? Is it just when you are querying, or when you are updating? Please edit your question to show examples of this behaviour. — John Rotenstein, Aug 01 '20 at 22:54
@JohnRotenstein Thanks and I just figured out I need to select 'autocommit' under connection profile, and that fixed it. — Crubal Chenxi Li, Aug 02 '20 at 16:35

score 1 · Answer 1 · answered Aug 02 '20 at 16:35

1

Select 'autocommit' under connection profile page works for me.

answered Aug 02 '20 at 16:35

Crubal Chenxi Li

159
2
11

Glad you figured it out! That commit stuff can be annoying. – John Rotenstein Aug 02 '20 at 23:14

Failed updating table for Redshift

1 Answers1