How can we improve Microsoft Azure SQL Data Warehouse ?

ANSI joins support in UPDATE & DELETE statement

SQL DW does not support to usual way of joins (ANSI) in UPDATE, DELETE statement. This makes difficult in case of table data modification. Though there is a workaround provided for CTAS this seems to be a lengthy process of data modification. Please have this feature available in SQL DW.

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

We’ll send you updates on this idea

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

3 comments

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

    Writing complex update/delete statements without this is counter to habits formed from other databases. Result is slower than desired dev throughout sometimes.

Feedback and Knowledge Base