Forum Discussion
Post ProdigyHow do you delete specific rows from a Lakehouse table?
Hi arpost ,
Thanks for using Fabric Community.It is possible to delete rows in a Lakehouse table using Spark-SQL in notebooks. I have created a repro of the scenario. I have attached the screenshots for your reference.
Trying to delete the row which has value of 46134
Query succeeded
After deletion of the row:
You can refer this link for more information: Link1
Hope this helps. Do let us know if you have any further issues. Glad to help.
Helper II went exactly the same way but it doesn´t work for me. Are there any bugs at the moment?
Everything is fine without the where clause (deleting all the data) but not with a where clause, regardless if it´s a clause to text or date column.
Any suggestions?
Advocate VThese discussions should be still valid for Lakehouses (and probably Warehouses) without schema.
I heard that Lakehouse with schema has more deletion issues.
Is this the case?
