How can we improve Microsoft Azure SQL Data Warehouse ?

Add support for synonyms

CTAS to a new table is often a pattern that's used in DW for data processing workloads. Instead of RENAME OBJECT operations from old tables to the new ones using CTAS, it would be great if we can add synonym support to DW, so that switching to the new table is an atomic operation, and is reliable.

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

We’ll send you updates on this idea

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

2 comments

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

    I concur. A synonym can provide a layer of indirection in a DW environment so users can be protected from underlying data schema changes (like a semver label in source control. )

  • Dave Mulanaphy commented  ·   ·  Flag as inappropriate

    This would also be extremely useful if you use your 1 appliance for multiple environments (dev, test, integration). Currently we have to use a script that updates all cross database references to a hardcoded name because we can't use synonyms. It is a very error prone, manual process.

Feedback and Knowledge Base