user084115

Discussions

Using UPDATE statement in Redshift
Hi , I am trying to update a column in Redshift using UPDATE statement. But I am getting error If someone can suggest whats wrong with the code I tried this code- UPDATE "table1", SET "created_dt" = '01/07/2022' where "change_hint" = 'update' The output comes as - Whoops ! Something went wrong
Using ALTER TABLE in SQL Data Flow ?
I want to add a new column in my dataset while working in SQL Data Flow . Can I use ALTER TABLE command ?