Rename a column name in SQLDW
Scenario: We want to change the column name as it is changed in the source. And in table where we are trying to do has more than 20Billion records.
Workaround: Since rename of column is not possible currently in SQL DW we are doing CTAS of that big table.
Issues With Work around: It is very slow because we can’t do CTAS on entire big table in single transaction because of transaction limits and we end up doing in CTAS and with multiple insert statements . Which is very time consuming process
ASK: Please support column Rename
Thanks for your suggestion. We are looking into this scenario for a future release. 10697387
M Lam commented
Question - can it be achieved this way:
1) alter table add new column
2) update table set new column = old column
3) alter table drop old column