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.
2 Comments
- SJCuthbertson
Advocate I
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. I'd like to pull data using Data flow, and spark from sql server of type synonyms, point to old tables on other databases or other table names to move data between connections since we cannot change the database on a gateway connector we have to completely code it again and change connections, but what if I'm not the developer, I'm the dba, and I don't want to break down stream objects but I need to move data in the sql box, synonyms would help.
