Warehouse table not deleting from interface

[ivamsikrishna]

Hi, we are facing typical issue with Microsoft Fabric warehouse. We created a table and dropped (after deleting the data) but we still see the table in the schema (on the leftside under schema ancestor) and if we do a select command on that very specific table it was showing table or view doesnot exist. It is strange, is it something known issue, physically table deleted but on the user interface it is still visible (it causing very confusion). Is anyone face the same issue, please help us resolving the same.  

Thanks. 

Krishna.

[v-prasare · Accepted solution]

Hi @ivamsikrishna,

This is a known UI behavior in Microsoft Fabric Warehouse. Even after a table is dropped, it may still show up in the schema explorer due to metadata caching in the UI. However, if you query the table and it returns "does not exist," then the table has been correctly dropped at the backend.

You can safely refresh the schema pane (right-click → Refresh) or reopen the warehouse tab to clear the UI cache. This doesn’t affect actual data operations and is just a temporary UI artifact.

Thanks,

Prashanth

[v-prasare · Accepted solution]

Hi @ivamsikrishna,

This is a known UI behavior in Microsoft Fabric Warehouse. Even after a table is dropped, it may still show up in the schema explorer due to metadata caching in the UI. However, if you query the table and it returns "does not exist," then the table has been correctly dropped at the backend.

You can safely refresh the schema pane (right-click → Refresh) or reopen the warehouse tab to clear the UI cache. This doesn’t affect actual data operations and is just a temporary UI artifact.

Thanks,

Prashanth

[v-prasare]

@ivamsikrishna  As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @ivamsikrishna ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare · Accepted solution]

Hi @ivamsikrishna,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query