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.
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
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.