How can we improve Microsoft Azure SQL Data Warehouse ?

MERGE statement support

Support the MERGE sql statement to support management of SCD1 / SCD2

323 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

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

15 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Can anyone help me with CTAS code for dealing with SCD type 2? I think it's suitable for UPSERT, but not SCD 2 type. Any piece of sample but working code would help.

  • Ramana Daliparthy commented  ·   ·  Flag as inappropriate

    Guys.. the last response says "Under Review" and is from June 20, 2016. What's the update on this AFTER 2.5 YEARS ???. People can really use this feature. Can you please give us a latest update.

  • Wade Rodriguez commented  ·   ·  Flag as inappropriate

    Have been vetting Informatica VS. SSIS while building an EDW in Azure Cloud... It seems Informatica has an Upsert feature... I would rather use SSIS, but there is no "Merge" functionality in Azure SQL Data Warehouse... When will Azure DW support "MERGE"... It's hugely helpful specifically for incremental loading of the Azure DW...

  • Anonymous commented  ·   ·  Flag as inappropriate

    This would be very useful for an implementation that is being planned - I made the mistake of assuming it was already available! Is there currently a best practice work around for SCD2?

  • Ralph Kemperdick commented  ·   ·  Flag as inappropriate

    For any DWH implementation, this convenient statement has been used in our code all over the place. Not having MERGE is causing a lot of pain moving our code to SQL DW. PLEASE provide a smooth transition to the cloud, by having MERGE in SQL DW.

Feedback and Knowledge Base