Forum Discussion
Creating a Table Shortcut in Fabric from a Partitioned Delta Table
Interesting. I've never tried creating shortcuts in a schema enabled Lakehouse myself. Are you sure you want to use the schema enabled Lakehouse? It's only a preview feature...
Is this part of the documentation relevant for your case (did you try the schemas shortcut option)? https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-schemas#bring-multiple-tables-with-schema-shortcut
frithjof_v Thank you for your reply. I have tried both. I created two testing Lakehouses, one with Schemas enabled and one normal one. In the normal one, I can create shortcuts from these partitioned tables without error. From the Schema Lakehouse, I get this "Unable to load table view" both when trying to use a shortcut and when trying to use Load to Table.
Interesting. I've never tried creating shortcuts in a schema enabled Lakehouse myself. Are you sure you want to use the schema enabled Lakehouse? It's only a preview feature...
Is this part of the documentation relevant for your case (did you try the schemas shortcut option)? https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-schemas#bring-multiple-tables-with-schema-shortcut
I also tried the schema shortcut but it didn't work either unfortunately.
Not planning to use the schema enabled lakehouse anymore. I found a workaround for what I need so I can just resolve this issue. For my work-around, I wrote a CREATE SCHEMA script in the warehouse and created views within the schema I wanted them. Works fine for now. I wanted to have the tables in the schemas as well but it's fine for now.