Forum Discussion
Advocate ILakehouse tables still visible in SQL endpoint view - how do I remove them?
Hi nioj2S,
Kindly contact your tenant administrator or Fabric administrator for further assistance in resolving the issue.
If the issue persists, we sincerely recommend reaching out to the Microsoft Support Team through the link provided below. Submitting a support ticket will allow you to receive personalized insights related to your account and potential resolutions:
Microsoft Fabric Support and Status | Microsoft FabricIf you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.
I was in touch with Microsoft Support and the issue was that the original dataflow had managed to create a schema in the lakehouse, which was a lakehouse that did not support schemas. The steps they came up with to resolve the issue was:
1 - Create a Lakehouse with schema support.
2 - Using a Fabric notebook:
2.1 - Create the FIRMA1 schema in the new Lakehouse.
2.2 - Create a table called bl_project in the new schema with only 1 column.
2.3 - Copy the contents of the folder into the Lakehouse with the orphan tables.
3 - Wait for metadata synchronization to occur and check whether the orphan table returns the expected test column.
4 - Using a Fabric notebook:
4.1 - In the Lakehouse with the orphan tables, delete the bl_project folder.
5 - After metadata synchronization, check whether the bl_project table was removed.
6 - Repeat this process for all orphan tables.
7 - At the end, delete the FIRMA1 schema from the SQL endpoint.
Also, there was some issue with casing, so we had to use a piece of code to make sure that Spark ignored/didn't ignore capital ("BL_PROJECT" vs "bl_project").
This solved the issue. 🙂
Community SupportHi nioj2S,
Thank you for your update.
Before deleting a schema, it is essential to first remove any dependent objects within the schema. Failure to do so will result in the DROP SCHEMA command failing.
Based on the error message in the screenshot you have shared, it appears that you do not have the necessary permissions to delete the specific table (e.g., BL_PROJECT), which is a dependent object within the schema FIRMA1. If you do not have the required permissions to delete tables or schemas, kindly contact your administrator and request access. Additionally, please check with your administrator for any external policies that may be applied to the resource.
Once all policies have been reviewed and the required permissions have been granted, please re-run the queries and verify the results.
If you find our response helpful, we request you to mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.
- nioj2S
I am a workspace admin, is that not enough?