Support Synonyms in Fabric Warehouse

[matthias-bi]

Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code against another test database). Synonyms are lightweight and more resilitent than views.

This is more general than lakehouse short cuts. It is completely different from Clone.

At the moment it is not supported, please support.

[SJCuthbertson]

This would be incredibly powerful in combination with the recently-announced Materialized Lake Views (https://blog.fabric.microsoft.com/en-us/blog/announcing-materialized-lake-views-at-build-2025). We could declaratively define transformation logic in a lakehouse MLV, with the MLV referencing lakehouse shortcuts to other workspaces if needed; we could then create a synonym in an adjacent warehouse, referencing the gold/final MLV from the LH. Then we have pretty seamless data access from the WH if we want to do more SQL-aligned things with it thereafter.