Microsoft Fabric: Table Rot
Sometimes, tables "rot" in Microsoft Fabric.
You might try to query a view, and receive an error message that reads something like this:
Failed to complete the command because the underlying location does not exist. Underlying data description: table 'dbo.dirpartytable', file 'https://onelake.dfs.fabric.microsoft.com/[guid]/[guid]/Tables/dirpartytable/part-00000-[guid].c000.snappy.parquet'.
If they haven't been touched in a while, I find that the shortcuts get severed.
Here are the steps to restore:
- Go to the lakehouse
- Select the table in question
- Three dots -> Manage Shortcut
- Edit target
- Target details
- Connection - either pick an existing connection or create a new one (Make sure that the target URL is the environment that is connected to F&O)
- Select the data folder with the name of the table
- Update