Forum Discussion
Unable to Delete DataflowsStagingLakehouse
Hi Anonymous ,
We have a bug filed to delete the LH & WH upon deletion of the last.
Ideal workaround is to create a new Workspace as we cannot delete the stagging artifacts manually, but in your case this will not work.
So inorder to handle your case I request you create a support ticket so the team will be looking into this issue more closely.
Once you have a SR# , please do share that here, so that we can keep an eye on the same.
Thank you
HI Anonymous
There are no manually artifacts in the DataflowsStagingLakehouse.
However there are two automatically created atifacts which do not have delete option at all.
01. SQL Analytics Endpoint
02. Sematic Model
Both of these do not have delete option in contex menu and both are empty.
Most Valuable ProfessionalHi Anonymous so 2 things here:
1. Dataflows "DataflowsStagingLakehouse" should now not be appearing in your workspace, these have been hidden. Can you check if this is the case? Perhaps create another workspace with a dataflow and see if those artifacts show up.
2. The SQL Endpoint and Semantic Model are automatically created when you create a Lakehouse and can't be deleted.
Thank you AndyDDC for your insights.
Anonymous - Few other inputs:
1. SQL Analytics Endpoint and Sematic Model items have by default no option to be deleted. This is the same if you create a lakehouse yourself.
2. These items will soon be hidden from users so should not show at all, however if indeed the last dataflow is removed from the workspace the lakehouse and warehouse with the other related items should be removed. After certain time period these items gets removed with the garbage collection.
Hope this information is helpful.Hi Anonymous AndyDDC ,
Thank you for your support.
Please note that this was automatically created 1 week ago on creation of a dataflow. That dataflow was deleted 10 minutes after creation, so there should be nothing in workspace.
AndyDDC, I reproduced a similar scenario in a new workspace and issue not coming. However, I cannot stop using my current workspace due to business requirements.
Hi Anonymous ,
We have a bug filed to delete the LH & WH upon deletion of the last.
Ideal workaround is to create a new Workspace as we cannot delete the stagging artifacts manually, but in your case this will not work.
So inorder to handle your case I request you create a support ticket so the team will be looking into this issue more closely.
Once you have a SR# , please do share that here, so that we can keep an eye on the same.
Thank you