How can we improve Microsoft Azure SQL Data Warehouse ?

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

79 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Bart Baeyens commented  ·   ·  Flag as inappropriate

    I could not believe this is not implemented, such a basic feature??
    Anu news when this will finally be available?

  • AmSuk commented  ·   ·  Flag as inappropriate

    Can we please know when will this feature/scenario be enabled. Its a pretty basic requirement - must have.

  • M Lam commented  ·   ·  Flag as inappropriate

    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

Feedback and Knowledge Base