https://community.databricks.com/t5/data-engineering/break-production-using-a-shallow-clone/m-p/53932#M29929 <P>Hi,</P><P>If you create a shallow clone using the latest LTS, and drop the clone using a SQL warehouse (either current or preview), the source table is broken beyond repair. Data reads and writes still work, but vacuum will remain forever broken. I've attached a notebook that demonstrates this behaviour.</P><P>To me it looks like the 'drop table' command in the warehouse does not remove the reference to the source files.</P><P>Wanted solution:<BR />* fixed `drop table` in the SQL Warehouse<BR />* working delta table after `repair table`</P> Mon, 27 Nov 2023 09:26:37 GMT oosterhuisf 2023-11-27T09:26:37Z https://community.databricks.com/t5/data-engineering/break-production-using-a-shallow-clone/m-p/53932#M29929 <P>Hi,</P><P>If you create a shallow clone using the latest LTS, and drop the clone using a SQL warehouse (either current or preview), the source table is broken beyond repair. Data reads and writes still work, but vacuum will remain forever broken. I've attached a notebook that demonstrates this behaviour.</P><P>To me it looks like the 'drop table' command in the warehouse does not remove the reference to the source files.</P><P>Wanted solution:<BR />* fixed `drop table` in the SQL Warehouse<BR />* working delta table after `repair table`</P> Mon, 27 Nov 2023 09:26:37 GMT https://community.databricks.com/t5/data-engineering/break-production-using-a-shallow-clone/m-p/53932#M29929 oosterhuisf 2023-11-27T09:26:37Z https://community.databricks.com/t5/data-engineering/break-production-using-a-shallow-clone/m-p/54002#M29957 <P>To add to that: the manual does not state that this might happen</P> Mon, 27 Nov 2023 16:33:18 GMT https://community.databricks.com/t5/data-engineering/break-production-using-a-shallow-clone/m-p/54002#M29957 oosterhuisf 2023-11-27T16:33:18Z